From: SPAMBLOCK.Maxwell_Smart@ThePentagon.com.SPAMBLOCK (Brian Tkatch)
Newsgroups: comp.databases.oracle.server
Subject: Changing storage parameters on a table.
Date: Wed, 08 Aug 2001 22:56:54 GMT
Organization: Altopia Corp. - Usenet Access - http://www.altopia.com
Lines: 15
Message-ID: <3b71c304.6448796@news.alt.net>
X-Newsreader: Forte Free Agent 1.11/32.235


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