Re: Tables With Data

From: andrew_webby at hotmail <spam_at_no.thanks.com>
Date: Wed, 6 Jun 2001 11:17:44 +0100
Message-ID: <991822687.28880.0.nnrp-12.c30bdde2@news.demon.co.uk>

num_rows>0 surely?

;-)

"David Busby" <dbusby3_at_slb.com> wrote in message news:3B1D221E.1E690D80_at_slb.com...
> If you analyze all the tables then you can:
>
> SELECT TABLE_NAME,NUM_ROWS FROM DBA_TABLES
> WHERE NUM_ROWS >1;
>
>
> Arif wrote:
>
> > I have a schema with about 100 tables. However only 30 of these 100
> > tables have data (rows) in them. Is there a quick way to find out
> > these 30 tables.
> >
> > Thanks
> > AM
>
Received on Wed Jun 06 2001 - 05:17:44 CDT