Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Hierarchy of how table_name is resolved

Hierarchy of how table_name is resolved

From: Cale, Rick T (Richard) <RICHARD.T.CALE_at_saic.com>
Date: Thu, 28 Sep 2000 08:52:16 -0700
Message-Id: <10633.118164@fatcity.com>


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.

  1. Look in Rick schema for test_table.
  2. Use private synonym
  3. Use public synonym
Received on Thu Sep 28 2000 - 10:52:16 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US