RE: List of synonyms

From: Nirmal Kumar Muthu Kumaran <NIRMALK_at_qtel.com.qa>
Date: Fri, 16 Nov 2001 08:43:37 -0800
Message-ID: <F001.003C7749.20011116073521@fatcity.com>

SYSTEM_at_ORANS.QTEL.COM.QA> COLUMN OBJECT_NAME FORMAT A30 SYSTEM_at_ORANS.QTEL.COM.QA> SELECT owner, object_name, object_type FROM dba_objects WHERE object_type='SYNONYM';

OWNER                          OBJECT_NAME                    OBJECT_TYPE
------------------------------ ------------------------------ ------------------
SYS                            DEF$_AQCALL                    SYNONYM
SYS                            DEF$_CALLDEST                  SYNONYM
SYS                            DEF$_DEFAULTDEST               SYNONYM
SYS                            DEF$_ERROR                     SYNONYM
SYS                            DEF$_LOB                       SYNONYM
SYS                            DEF$_SCHEDULE                  SYNONYM
PUBLIC                         ALL_ALL_TABLES                 SYNONYM
PUBLIC                         ALL_ARGUMENTS                  SYNONYM
................

Rgds,
Nirmal.

-----Original Message-----

From:   Ramon Estevez [SMTP:com.banilejas_at_codetel.net.do]
Sent:   Friday, November 16, 2001 5:55 PM
To:     Multiple recipients of list ORACLE-L

Subject:        List of synonyms

Hi,
 

Does exist any view to check the list of synonyms in the DB.
 

Version 8.1.7
 
 

Regards,
 
 

Ramon E. Estevez
com.banilejas_at_codetel.net.do <mailto:com.banilejas_at_codetel.net.do> Dominican Republic
809-565-3121
 
Received on Fri Nov 16 2001 - 10:43:37 CST