I am attempting to set the PCTINCREASE value from 50 to 0 for the indexes of some LOB's. As far as I can understand the correect syntax is as follows:

altertable schema.table
modify lob (lob_column_name)
(index (storage (PCTINCREASE 0)));

where the lob_column_name is the name of the column in the table that contains the lob. I have run this SQL through the database and it is executed OK. Then when I check the PCTINCREASE Value for the index again it is still at 50. Am I actually changing the PCT Increase for the LOB usinmg this syntax.

Any assistance would be appreciated as I am now chasing my tail - so to speak.

PS:- I am using Oracle 8.1.7.2


[Edited by Eddy99 on 05-14-2002 at 04:29 AM]