Re: How do I find emty tables

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Tue, 15 May 2001 22:10:45 +0800
Message-ID: <3B0138E5.6F8F@yahoo.com>

Niklas Danielsson wrote:
>
> 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

Why can't you analye ? If its a rule based app, you could set this in init.ora and then analyze away to your hearts content.

hth
connor

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"

Received on Tue May 15 2001 - 09:10:45 CDT