ORACLE Available Tables

SELECT
  OWNER,
  TABLE_NAME
FROM ALL_TABLES
ORDER BY TABLE_NAME;


SELECT
  OWNER,
  TABLE_NAME
FROM ALL_TABLES@DB_LINK
ORDER BY TABLE_NAME;


Till Next Time