> -----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: [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).
