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 -> Re: How do I find emty tables

Re: How do I find emty tables

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 16 May 2001 22:39:02 +0800
Message-ID: <3B029106.2FDB@yahoo.com>

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

Analyze them with estimate - you only read a small portion of the table when this is done - and that is all will be needed to show which tables have no rows.

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 - 09:39:02 CDT

Original text of this message

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