Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> How does oracle resolve a reference to an object
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
-- http://www.freelists.org/webpage/oracle-lReceived on Mon May 15 2006 - 16:11:59 CDT
![]() |
![]() |