Re: Reclaim my space NOW!

Given that you don't want to drop or truncate the table, you can't. You've inserted rows, pushing the highwater mark up and dirtying blocks - you can't drag the high-water mark down again.

Given that you've inserted somewhere between 1,00 and 32,000 times as many rows as you had, why are you surprised that the table has grown to 6 Mb ?

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

atta707_at_my-deja.com wrote in message <87b4cc$ncf$1_at_nnrp1.deja.com>...
>dear all,
>
>please consider this, if you would:
>
>log on as scott/tiger;
>disable primary key for EMP;
>
>loop about 10 to 15 times
> -- incremental inserts...
> insert into EMP select * from EMP;
>end loop
>rollback;
>
>the number of extents allocated for emp grows to 15, about 6 mb of
>tablespace!
>
>now could anyone please help me with how to reclaim this space and get
>the EMP table to shrink back to it's legtimate size or, at least, to
>the size bofore this transaction took place?
>
>i'm reluctant to either drop or truncate this table!!!
Received on Thu Feb 03 2000 - 15:25:10 CST