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