Altering Storage on LOB Indexes
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Altering Storage on LOB Indexes

Hybrid View

  1. #1
    Join Date
    May 2002
    Posts
    19

    Angry

    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]

  2. #2
    Join Date
    May 2002
    Posts
    19
    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 !!!!!!!!!!!!!!!!!!!!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width