From: Thomas Kyte <tkyte@us.oracle.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Changing storage parameters on a table.
Date: 8 Aug 2001 16:46:41 -0700
Organization: Oracle
Lines: 32
Message-ID: <9ksj1102jus@drn.newsguy.com>
References: <3b71c304.6448796@news.alt.net>
NNTP-Posting-Host: p-803.newsdawg.com
X-Newsreader: Direct Read News v2.80


In article <3b71c304.6448796@news.alt.net>,
SPAMBLOCK.Maxwell_Smart@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@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