RE: Hierarchy of how table

From: Kimberly Smith <kimberly.smith_at_gmd.fujitsu.com>
Date: Thu, 28 Sep 2000 09:45:19 -0700
Message-Id: <10633.118168@fatcity.com>

Your version of the obvious is correct.

-----Original Message-----
From: Cale, Rick T (Richard) [mailto:RICHARD.T.CALE_at_saic.com] Sent: Thursday, September 28, 2000 10:00 AM To: Multiple recipients of list ORACLE-L Subject: Hierarchy of how table_name is resolved

Hi All,

I cannot seem to find in any docs on how Oracle determines resolution of table to access.

For ex say I have the following:

Public synonym name test_table
Private synonym under rick account name test_table. Rick owns a table name test_table

If Rick does select * from test_table;
what order does oracle use to resolve?

The obvious is the following but not sure.

Look in Rick schema for test_table.
Use private synonym
Use public synonym

Thanks
Rick

--

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). Received on Thu Sep 28 2000 - 11:45:19 CDT

RE: Hierarchy of how table_name is resolved