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 -> How do I find emty tables

How do I find emty tables

From: Niklas Danielsson <niklas.danielsson_at_eget.fi>
Date: Tue, 15 May 2001 13:37:12 +0300
Message-ID: <3B0106D8.C42783C@eget.fi>

Hello all!

I would like to find alla tables that are emty = 0 rows in the database. The problem is that I can't analyze the the tables so I can't use NUM_ROWS in DBA_TABLES.

Is there any other way?

TIA niklas.danielsson_at_eget.fi Received on Tue May 15 2001 - 05:37:12 CDT

Original text of this message

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