Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Reclaim my space NOW!
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.
--
![]() |
![]() |