Re: Empty Table

Probably the easiest is to analyze the schema and then select
table_name from dba_tables where numrows (sp?) = 0.

Or you could select count(*) from all tables with some dynamic SQL,
but if any of the tables are large, that could get time and CPU
consuming.

HTH
Stephen


On Sun, 23 Jan 2005 20:06:42 -0800 (PST), Kean Jacinta
<jacintakean@xxxxxxxxx> wrote:
> Hello
> 
> I need some help here. I need to get a report of all
> the table that are empty on a schema.
> 
> How shall i do that ?
> 
> Thank In advance
> 
> JK
> 
> 
> __________________________________
> Do you Yahoo!?
> Yahoo! Mail - Easier than ever with enhanced search. Learn more.
> http://info.mail.yahoo.com/mail_250
> --
> http://www.freelists.org/webpage/oracle-l
>
--
http://www.freelists.org/webpage/oracle-l

Other related posts: