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

Home -> Community -> Mailing Lists -> Oracle-L -> Public synonyms

Public synonyms

From: Andrey Bronfin <Andreyb_at_maxbill.com>
Date: Sun, 24 Jun 2001 06:50:34 -0700
Message-ID: <F001.003359D4.20010624061019@fatcity.com>

Dear all !
I have an empty schema named AAA .
select * from obj returns 0 rows .
When i do select * from some_table , rows are returned  . I guess that some_table is a public synonym . How can i verify it ?
How can i see in which schema is it defined ?

Thanks a lot !
Andrey. Received on Sun Jun 24 2001 - 08:50:34 CDT

Original text of this message

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