From: "andrew_webby at hotmail" <spam@no.thanks.com>
Newsgroups: comp.databases.oracle.misc
Subject: Re: Tables With Data
Date: Wed, 6 Jun 2001 11:17:44 +0100
Message-ID: <991822687.28880.0.nnrp-12.c30bdde2@news.demon.co.uk>
References: <3f2585f1.0106050910.4b7b7225@posting.google.com> <3B1D221E.1E690D80@slb.com>
NNTP-Posting-Host: mailgate.highland.gov.uk
X-NNTP-Posting-Host: mailgate.highland.gov.uk:195.11.221.226
X-Trace: news.demon.co.uk 991822687 nnrp-12:28880 NO-IDENT mailgate.highland.gov.uk:195.11.221.226
X-Complaints-To: abuse@demon.net
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MIMEOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
Lines: 23


num_rows>0 surely?

;-)

"David Busby" <dbusby3@slb.com> wrote in message
news:3B1D221E.1E690D80@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
>