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 !!!!
Click Here to Expand Forum to Full Width