synonym on synonym is it possible.

From: Tapan Trivedi <tapan.trivedi_at_abbnm.com>
Date: Thu, 23 Sep 1999 12:00:23 GMT
Message-ID: <6EC14873F507D3119B8C0090273C4349067A2F@jdasoftware.com>

Hey guys,
 i have a problem with a user trying to create a synonym on a synonym. Is it possible to do this.

create public synonym dingdong for ranger.sogen1; ( SOGEN1 is itself a synonym on another table.) ›1]Synonym created.
SQL> select * from dba_synonyms where SYNONYM_NAME like 'DINGDONG';

OWNER                          SYNONYM_NAME                  
TABLE_OWNER                    TABLE_NAME                     DB_LINK


------------------------------ ------------------------------


------------------------------ ------------------------------


-------------------------
PUBLIC                         DINGDONG                      
RANGER                         SOGEN1

SQL> desc dingdong
Object does not exist.
Why does this happen ?

Any hints,experiences,suggestions will be appreciated.

                                        Thanks a lot.

                                                        Tapan H Trivedi

Received on Thu Sep 23 1999 - 07:00:23 CDT