Modify INITRANS for existing BLOCKS
We have Oracle 8i(8.1.7) database running on True64 V5.1B. We want to migrate it to Oracle 10g R2. I installed Oracle 10g R2 S/W and did an export and import into Oracle 10g R2 database. The import was successful without any warnings. Auto Segment Space Management in 10g manages PCT_USED and FREELISTS. So this solved FREELISTS problem. But, INITRANS is still same.
1) So, We want to increase the INITRANS parameter for all the TABLES and INDEXES. As we know the default for TABLES is 1 and for INDEXES is 2. If we use ALTER TABLE/INDEX to change the value of INITRANS, it will affect only the NEW BLOCKS (From Oracle Documentation). So, it will not affect or change INITRANS for the existing DATA BLOCKS/INDEX BLOCKS. I would like to know if there is a way to change INITRANS for the existing DATA BLOCKS/INDEX BLOCKS.
2) Is there a way to check these values for all the DATA/INDEX BLOCKS in a SEGMENT(TABLE/INDEX). I mean from some DATA DICTIONARY VIEWS?
3) Is there a way to change
Click Here to Expand Forum to Full Width