Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Reclaim my space NOW!

Re: Reclaim my space NOW!

From: Andreas Michler <Andreas.Michler_at_adicom.de>
Date: Thu, 03 Feb 2000 13:20:12 +0100
Message-ID: <3899727B.F54B989@adicom.de>


drop user scott cascade;

the run script scott.sql from oracle installation directory (rdbms/admin).

Then you have a newly installed emp table.

atta707_at_my-deja.com wrote:

> 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!!!
>
> thanks in anticipation.
>
> ATTA
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

--



ADICOM Informatik GmbH
Andreas Michler
Wiesfleckenstr. 34
72336 Balingen
Tel: 07433/9977-57,Fax: -90
E-Mail: Andreas.Michler_at_adicom.de
http:\\www.adicom.de
Received on Thu Feb 03 2000 - 06:20:12 CST

Original text of this message

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