RE: how to release blocks of table?

> -----Original Message-----
>
> The way to decrease the initial size is 'alter table xxx
> deallocate unused
> keep nnn'.
> I found it in the doc after sending the previous msg.
>

Another possibility: If the storage specifications for the tables in the database are acceptable, and you are the one doing the export, you can specify "compress=n" when you do the export. Then the initial extent will be as specified when the original table was created. Some shops create large tables with a small initial extent for this reason: When they only want the schema structure in someplace else, they can get it without the big initial extents.

You can also use emacs to directly modify the export file to change the storage parameters therein.

Something similar to the following:

Create the file fix-extents.el with the following: (beginning-of-buffer)
(while (re-search-forward "INITIAL[ 0-9]*NEXT[ 0-9]*MINEXTENTS" nil t)

    (replace-match "INITIAL 1M NEXT 1M MINEXTENTS" nil nil)) (save-buffer)
Run the following to fix the dump file test.dmp: emacs -batch test.dmp -l fix-extents.el

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephen Lee
  INET: slee_at_dollar.com

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: ListGuru_at_fatcity.com (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).