Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Tables With Data

Re: Tables With Data

From: David Busby <dbusby3_at_slb.com>
Date: Tue, 05 Jun 2001 13:17:03 -0500
Message-ID: <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

Received on Tue Jun 05 2001 - 13:17:03 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US