Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Tables With Data
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