Re: Empty Table

  • From: Mladen Gogala <gogala@xxxxxxxxxxxxx>
  • To: jacintakean@xxxxxxxxx
  • Date: Mon, 24 Jan 2005 05:12:37 +0000

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


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

Other related posts: