From jkstill@cybcon.com Wed, 14 Mar 2001 12:26:19 -0800 From: jkstill@cybcon.com Date: Wed, 14 Mar 2001 12:26:19 -0800 Subject: Re: Order of table_name resolution Message-ID: MIME-Version: 1.0 Content-Type: text/plain Here's more than you wanted to know about name resolution: http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/appdev.817/a77069/d_names.htm#3693 Jared On Wed, 14 Mar 2001, Cale, Rick T (Richard) wrote: > 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@saic.com > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: jkstill@cybcon.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@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).