If you are using at least 8i, "alter table move...." should do the trick.
> -----Original Message----- > From: Yechiel Adar [mailto:adar76@;inter.net.il] > Sent: Thursday, October 17, 2002 2:20 PM > To: Multiple recipients of list ORACLE-L > Subject: how to release blocks of table? > > > I need to release blocks belonging to the initial extent of a table. > CTAS is not an option. > Optionally how can I decrease the value of initial extent > so I can export and import into smaller size. > > I have a 7GB database that I need to run a script that was given by > supplier. This script rebuild all the indexes and I want to > make sure that > none are forgotten (~ 700). > I have enough space for one but not for two. So I thought to > import with > rows=no twice, run the scripts against one schema and use > toad to compare > the schemas. > The problem is initial extents in the export file that fill > all the new DB. > If I can decrease the initial extents then I will export and > import the > whole schema and have enough space. > > Yechiel Adar > Mehish > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Yechiel Adar > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).