Re: how to release blocks of table?

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 <ORACLE-L_at_fatcity.com> 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: 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Yechiel Adar
  INET: adar76_at_inter.net.il

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