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:
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 220.127.116.11
[Edited by Eddy99 on 05-14-2002 at 04:29 AM]
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 !!!!