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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Empty Table

Re: Empty Table

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Mon, 24 Jan 2005 05:12:37 +0000
Message-Id: <1106543557l.28491l.0l@medo.noip.com> 






On 01/23/2005 11:06:42 PM, Kean Jacinta wrote:



=20


> I need some help here. I need to get a report of all

> the table that are empty on a schema.





You could run something like DBMS_STATS.GATHER_SCHEMA_STATS('SCHEMA') =20
and  then report all tables with NUM_ROWS>1000000



--=20


Mladen Gogala


Oracle DBA



--
http://www.freelists.org/webpage/oracle-l


Received on Mon Jan 24 2005 - 00:15:08 CST












Original text of this message













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