Thanks Mladen and Lee I am always amazed by the ability and knowledge of the people on this list. You guys (all the list members) always come up with many options to do something so if some option does not work you have others.
Yechiel Adar Mehish ----- Original Message ----- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, October 17, 2002 9:13 PM > > > > -----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). -- 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).
