Re: Empty Table
- From: Jared Still <jkstill@xxxxxxxxx>
- To: andert@xxxxxxxxx
- Date: Mon, 24 Jan 2005 18:56:54 +0000
Mitigating the risk of checking potentially large table is
easy with a simple modification.
add a where clause:
WHERE rownum < 2;
Any table with a single row is obviously not empty.
Jared
On Sun, 23 Jan 2005 21:45:50 -0700, Stephen Andert <andert@xxxxxxxxx> wrote:
> 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
> > --
> > //www.freelists.org/webpage/oracle-l
> >
> --
> //www.freelists.org/webpage/oracle-l
>
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
//www.freelists.org/webpage/oracle-l
Other related posts:
