Re: Synonym question (possibly hidden tables)

Hi,
If you would like to know if it is a synonym, you could try "select table_name
 from dba_synonyms
 where table_name like 'ABC%';"
Could it be a view, instead.
You could also try something like
"Select owner,object_name,object_type
 from dba_objects
 where object_name like 'ABC%';"

I hope this helps.
Guy.

sks_at_scminc.com wrote:

> Greetings,
>
> I've been looking at the the table structure of some data
> and have found that I can access some tables that don't show
> up in "all tables" ie via a "select table_name from all_tables".
>
> Are these "mystery tables" actually synonyms? If so, how
> do I go about finding out what synonyms are out there?
>
> Ps. I've running the queries as the system user, so I should have
> access to everything.
>
> Thanks,
> Sujay S.
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Wed Feb 10 1999 - 21:50:30 CST