Database/Oracle

Oracle - List all tables existent in a Database Link

하루y 2019. 10. 14. 00:05
SELECT OWNER, TABLE_NAME
  FROM ALL_TABLES@DB_LINK_NAME
 WHERE OWNER NOT IN ('SYS', 'SYSTEM')
ORDER BY OWNER, TABLE_NAME
 

 

728x90