Any table should be listed in DBA_TABLES. If it has been analyzed the
num_rows column in that same table will tell you if it has data.

I believe DBA_SEGMENTS will give you the size in bytes of the table.

-----Original Message-----
From: Stenquist, Janice M [mailto:janice.[Email Address Removed]
Sent: Wednesday, April 21, 2004 8:17 AM
To: LazyDBA.com Discussion
Subject: List tables and current data size


I need to verify that a table is in the DB and is populated with data,
and how large it is......the select command would be?????

Janice

--------
Get today's cartoon: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] using this list you agree to these
terms:http://www.lazydba.com/legal.html



Anadarko Confidentiality Notice:
This electronic transmission and any attached documents or other writings
are intended only for the person or entity to which it is addressed and may
contain information that is privileged, confidential or otherwise protected
from disclosure. If you have received this communication in error, please
immediately notify sender by return e-mail and destroy the communication.
Any disclosure, copying, distribution or the taking of any action concerning
the contents of this communication or any attachments by anyone other
than the named recipient is strictly prohibited.

Oracle LazyDBA home page