Re: Space and fragmentation in Oracle 7.3.4

From: James Belton <jbelton_at_freenetname.co.uk>
Date: Thu, 2 Dec 1999 15:08:44 -0000
Message-ID: <8261vc$7qi$1@gxsn.com>

try alter table <tablename> deallocate unused

as well!

James

James Belton wrote in message <82610u$4h6$1_at_gxsn.com>...
>Eric,
>
>The problem is that you have a high water mark on the table.
>
>Unfortunately, even though there is only one row in the table, when Oracle
>does a full table scan, it is reading the space a full 1000000 records
would
>take. Hence, it is slow.
>
>The only way around this is to either truncate the table or to drop and
>recreate it using import / export.
>
>Hope this helps!
>
>James
>
>DBA hints and tips at http://www.jamesbelton.co.uk
>>
>
>
Received on Thu Dec 02 1999 - 09:08:44 CST