All the information OEM displays is stored in tables in the data dictionary.
Information about all the tables in the database, for example, is stored in
the user_tables, all_tables, and/or dba_tables tables.


Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC

-----Original Message-----
From: Tushar Amin
[mailto:oracledba-ezmlmshield-x39017053.[Email address protected]
Sent: Saturday, May 29, 2004 10:31 PM
To: LazyDBA.com Discussion
Subject: view datastructure in oracle without using oem

hi

how can i see the data structure available for a particular database in
oracle 9i without using oem for e.g if i want to find out how many tables
are there in my database without looking at oem

thanks

tushar




--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe: see
http://www.lazydba.com/unsubscribe.html
To subscribe: send a blank email to oracledba-[Email address protected]
By using this list you agree to these
terms:http://www.lazydba.com/legal.html








Oracle LazyDBA home page