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 22.214.171.124
[Edited by Eddy99 on 05-14-2002 at 04:29 AM]
Click Here to Expand Forum to Full Width