Re: How do I find emty tables

From: Niklas Danielsson <niklas.danielsson_at_eget.fi>
Date: Wed, 16 May 2001 10:47:38 +0300
Message-ID: <3B02309A.6CA77C38@eget.fi>

Hi Connor,

Sorry for being so vague when I described the problem.

Sure I can analyze all tables but that is something that I do not want to do when the
dB is in use, I'm afraid that something will go wrong or that it will take a lot of
performance.

Connor McDonald wrote:

> 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 Wed May 16 2001 - 02:47:38 CDT