How does oracle resolve a reference to an object

From: genegurevich@xxxxxxxxxxxxxxxxxxxxx
To: oracle-l@xxxxxxxxxxxxx
Date: Mon, 15 May 2006 16:11:59 -0500

Hi all:

If  I have a table named TABLE in a database, a public synonym named TABLE
that points to this database
and a private synonym TABLE that points to a table called TABLE2, what is
the order in which these objects
will be picked by Oracle? Is that - private synonysm followed by public
synonym followed by the table?

In other words if I execute select * from  TABLE and I have a private
synonym TABLE that points to TABLE2,
will that SQL go against the TABLE2?

thank you

Gene Gurevich








--
//www.freelists.org/webpage/oracle-l

Follow-Ups:
- Does a lock on a parent table locks up alter table disable constraint?
  - From: genegurevich
- Re: How does oracle resolve a reference to an object
  - From: Jared Still

References:
- ORA-4031
  - From: Tracy Rahmlow

How does oracle resolve a reference to an object

Other related posts: