Re: LONG: Re: Order of table_name resolution

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:teci_dba1_at_hotmail.com]
> > 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: teci_at_oracle-dba.com

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: ListGuru_at_fatcity.com (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).