Xref: alice comp.databases.oracle.server:83174
Path: alice!news-feed.fnsi.net!newspump.monmouth.com!newspeer.monmouth.com!news.maxwell.syr.edu!nntp2.deja.com!nnrp1.deja.com!not-for-mail
From: atta707@my-deja.com
Newsgroups: comp.databases.oracle.server
Subject: Reclaim my space NOW!
Date: Thu, 03 Feb 2000 05:40:28 GMT
Organization: Deja.com - Before you buy.
Lines: 29
Message-ID: <87b4cc$ncf$1@nnrp1.deja.com>
X-Article-Creation-Date: Thu Feb 03 05:40:28 2000 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 4.01; Windows NT)
X-Http-Proxy: 1.0 JOHNYBRAVO, 1.0 cache4-squid.pol.com.pk:8080 (Squid/2.3.STABLE1), 1.0 x37.deja.com:80 (Squid/1.1.22) for client 202.179.149.105, 209.198.254.137
X-MyDeja-Info: XMYDJUIDatta707

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.