Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Changing storage parameters on a table.
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 CorpReceived on Wed Aug 08 2001 - 18:46:41 CDT