For tables -

You can query CATALOGUE, DICTIONARY, TABLE..... /- Vin

-----Original Message-----
From: Tushar Amin
[mailto:oracledba-ezmlmshield-x39017053.[Email address protected]
Sent: Wednesday, June 30, 2004 7:21 AM
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