Re: how to list all tables in sqlplus
From: Wiktor <wiktor_at_legnica.americanos.com.pl>
Date: Fri, 24 Nov 2000 10:20:23 +0100
Message-ID: <8vlc1h$e18$1_at_kujawiak.man.lodz.pl>
Date: Fri, 24 Nov 2000 10:20:23 +0100
Message-ID: <8vlc1h$e18$1_at_kujawiak.man.lodz.pl>
> Where are these user_tables, all_tables, dba_tables, and dba_objects
created?
> My machine does have the user_talbes and all_tables but does not have
> dba_tables and dba_objects. Why? I was logged in as DBA/DBO.
>
dba_tables/all_tables, dba_objects/all_objects are:
VIEWs in SYS schema based on TABLES like sys.obj$,sys.user$... and
SYNONYMs in PUBLIC schema.
So, if U cant see dba_tables, probably U dont have public synonym for it
Informations about objects U have in all_objects(owner,type) is it what U
need?
Best Regards
Viki
Received on Fri Nov 24 2000 - 10:20:23 CET