Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Changing storage parameters on a table.

Re: Changing storage parameters on a table.

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 8 Aug 2001 16:46:41 -0700
Message-ID: <9ksj1102jus@drn.newsguy.com>

In article <3b71c304.6448796_at_news.alt.net>, SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK says...
>
>To change the storage space on a lob segment, I can use the modify lob
>storage clause of the ALTER TABLE statement.
>
>ALTER TABLE Moo MODIFY LOB (Cow) (STORAGE (NEXT 100M PCTINCREASE 0));
>
>How do I change the rest of the table?
>
> ALTER TABLE Moo MOVE STORAGE (NEXT 100M PCTINCREASE 0);
>
>But then I have to rebuild all the indexes. Also, the MOVE clause
>sounds a bit extreme. Is there another way?
>
>Brian
>
>

ops$tkyte_at_ORA8I.WORLD> alter table t storage ( next 1m );

Table altered.

....

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp 
Received on Wed Aug 08 2001 - 18:46:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US