RE: RE: Hierarchy of how table

From: Kimberly Smith <kimberly.smith_at_gmd.fujitsu.com>
Date: Thu, 28 Sep 2000 11:50:15 -0700
Message-Id: <10633.118171@fatcity.com>

Hum,
never even thought view but you are correct. I think I will have the cookie anyway but not the glass of milk...

-----Original Message-----
From: dgoulet_at_vicr.com [mailto:dgoulet_at_vicr.com] Sent: Thursday, September 28, 2000 11:09 AM To: Kimberly Smith; Multiple recipients of list ORACLE-L Subject: Re:RE: Hierarchy of how table_name is resolved

OOOH, damn close, but you just missed the cookie.

table owned by user
view owned by user
private synonym
public synonym

I think you may have gotten that chocolate chip that was leaning out the side
though.

Dick Goulet

____________________Reply Separator____________________

Subject: RE: Hierarchy of how table_name is resolved Author: Kimberly Smith <kimberly.smith_at_gmd.fujitsu.com> Date: 9/28/00 9:46 AM

Your version of the obvious is correct.

-----Original Message-----
Sent: Thursday, September 28, 2000 10:00 AM To: Multiple recipients of list ORACLE-L

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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Kimberly Smith
INET: kimberly.smith_at_gmd.fujitsu.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

RE: RE: Hierarchy of how table_name is resolved