Altering Storage on LOB Indexes

[Eddy99]

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]

[Eddy99]

Well I have since found out

Bug:1244654 "UNABLE TO CHANGE STORAGE CHARACTERISTICS FOR LOB INDEXES".

The suggested workaround is to

Export the table,
Drop & recreate, table with desired lob index storage characteristics,
Import table data

This is not an acceptable workaround, as it would lead to unscheduled downtime of production system !!!!

Aaaarggggghhhhhhh !!!!!!!!!!!!!!!!!!!!!