Re: how many deleted records has a table

From: Harald Maier <maierh_at_myself.com>
Date: Thu, 30 Oct 2003 17:05:51 +0100
Message-ID: <m3llr2sobk.fsf@ate.maierh>

ronald.goeggel_at_atosorigin.com (Ronald) writes:

> 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.

Hallo Ronald,

you may look in the Database Concepts Manual (a96524 for Oracle 9i or a76965 for Oracle 8.1.6). It discusses all the logical an physical storage structures.

Harald

PS: Our last meeting was really funny. Please, greet the other colleagues. Received on Thu Oct 30 2003 - 10:05:51 CST