Oracle PL/SQL/System Tables Views/DBA SYNONYMS

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>