Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: knowing the tables in the user account / schema?
On 6 Feb 2002 23:31:48 -0800, akshaysalkar_at_joymail.com (DukeNM) wrote:
>how to know what are the tables, view, etc. present for a specific
>user if i am the dba.
Select * from Dba_Objects...
Check out the Columns in the DBA_OBJECTS ... They are self explnatory....
[Additions and Corrections Always Welcome.]
Best Regards,
Ganesh R
Received on Thu Feb 07 2002 - 02:28:31 CST