My apologies to all by NOT denoting i ripped that entire piece out of
the 817 docs.
apps devleoper guide, chapter 2, schema maintenance.
joe
> Jacques Kilchoer wrote:
>
> > -----Original Message-----
> > From: Joseph Testa [mailto:[EMAIL PROTECTED]]
> > Due to the possibility of synonyms, the
> > following rules are used to resolve a name in a context that
> > requires an
> > object in the table namespace:
>
> etc...
>
> That was an excellent post Mr. Testa. My chapeau goes off to you.
> Also it seems that Oracle keeps track of the names it goes through
> when doing synonym resolution, as the example below shows:
>
> SQL> create synonym x for y ;
>
> Synonym created.
>
> SQL> create synonym y for x ;
>
> Synonym created.
>
> SQL> select * from x ;
> select * from x
> *
> ERROR at line 1:
> ORA-01775: looping chain of synonyms
>
> ------
> any ignorant comments made are the sole responsibility of J. R.
> Kilchoer and should not reflect adversely upon my employer.
>
>
> Jacques R. Kilchoer
> (949) 754-8816
> Quest Software, Inc.
> 8001 Irvine Center Drive
> Irvine, California 92618
> U.S.A.
> http://www.quest.com
--
Joe Testa http://www.oracle-dba.com
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Joseph S. Testa
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
