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