Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

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>