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: Brian Peasland <peasland_at_usgs.gov>
Date: Thu, 7 Jun 2001 12:42:08 GMT
Message-ID: <3B1F76A0.494D6BAC@usgs.gov>

Another way to do this (without analyzing tables) is to export the schema. The export will show exactly how many rows are in each table!

HTH,
Brian

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
 

-- 

====================================
Brian Peasland
peasland_at_usgs.gov
Raytheon at USGS EROS Data Center
Mundt Federal Building
Sioux Falls, SD 57198
Received on Thu Jun 07 2001 - 07:42:08 CDT

Original text of this message

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