Re: how many deleted records has a table

From: Norman Dunbar <Norman_at_RE-MO-VE.BountifulSolutions.co.uk>
Date: Fri, 31 Oct 2003 08:01:16 +0000
Message-ID: <pan.2003.10.31.08.01.16.457302@RE-MO-VE.BountifulSolutions.co.uk>

On Thu, 30 Oct 2003 01:38:43 -0800, Ronald wrote:

> I had a table of 15 million records.
>
> After deleting all records (using the delete command) I have to wait
> about 1 minute for a "select count(*)". The result was that it
> contained 0 records.
>
> After recreating the table the problem was solved.
>
> Therefore I want to check on each table how many deleted records they
> involve.
>
> I am using ORACLE 8.1.6.
>
> Ronald

Hi Ronald,

have a look here for an explanation :

http://www.jlcomp.demon.co.uk/faq/trunc_del.html

Regards,
Norman.

-- 
Delete the obvious bit from my email address to reply by email.

Received on Fri Oct 31 2003 - 02:01:16 CST