Re: synonym on synonym is it possible.

From: Karen Abgarian <karen.abgarian_at_fmr.com>
Date: Wed, 22 Sep 1999 15:00:33 -0400
Message-ID: <37E92751.7016052F@fmr.com>

You can create synonyms on synonyms as you please. The only thing that should be understood is that Oracle resolves a synonym at reference time, not at creation time. Back to the particular example, check if you have access to objects referenced by RAGEN.SOGEN1.

Regards,
Karen Abgarian.

Tapan Trivedi wrote:

> 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
>
> ------------------------------------------------------------------------
>
> Tapan Trivedi <tapan.trivedi_at_abbnm.com>
>
> Tapan Trivedi
> <tapan.trivedi_at_abbnm.com>
> Pager: 281 262 5866
> Home: 713 218 8133
> Work: 281 274 5193
> Additional Information:
> Last Name Trivedi
> First Name Tapan
> Version 2.1
Received on Wed Sep 22 1999 - 14:00:33 CDT