Get DBA SYNONYMS
SQL>
SQL> SELECT synonym_name, table_owner, table_name
2 FROM DBA_SYNONYMS where rownum < 10;
SYNONYM_NAME TABLE_OWNER TABLE_NAME
------------------------------ ------------------------------ ------------------------------
DUAL SYS DUAL
SYSTEM_PRIVILEGE_MAP SYS SYSTEM_PRIVILEGE_MAP
TABLE_PRIVILEGE_MAP SYS TABLE_PRIVILEGE_MAP
STMT_AUDIT_OPTION_MAP SYS STMT_AUDIT_OPTION_MAP
MAP_OBJECT SYS MAP_OBJECT
DBMS_STANDARD SYS DBMS_STANDARD
V$MAP_LIBRARY SYS V_$MAP_LIBRARY
V$MAP_FILE SYS V_$MAP_FILE
V$MAP_FILE_EXTENT SYS V_$MAP_FILE_EXTENT
9 rows selected.
SQL>
Related examples in the same category