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_at_yahoo.com> 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