Re: Order of table_name resolution

yes i think u r right.
at this oracle seems to follow this sequence. but is there any way to know the exact path of sequence..

saurabh
----- Original Message -----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Wednesday, March 14, 2001 6:30 PM

> Hi DBAs,
>
> Can someone clarify/confirm on how Oracle determines what table to use in
> select statement?
>
> For ex. If I am login as Scott and do the following:
>
> SELECT * FROM employee;
>
> Of course Oracle will use Scott.employee if it exist. If it does not exist
> but exist under another schema. Does
> Oracle look at private synonyms then public synonyms or vice versa.
>
> My guess is Oracle checks in this order. Please confirm or correct.
>
> 1. Check if table exist in current schema
> 2. Check private synonyms
> 3. Check public synonyms
> 4. 3 strikes your out with an error.
>
> Rick Cale, Science Applications International Corp.
> Phone:865-481-2198, fax:865-481-8555
> e-mail: caler_at_saic.com
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Cale, Rick T (Richard)
> INET: RICHARD.T.CALE_at_saic.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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Saurabh Sharma
  INET: saurabhs_at_fcsltd.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).