Version 11.2.0.2.0
Hello guys, got little stuck at changing the INITRANS parameter for a table partition. The table is partitioned by range.
To modify the INITRANS and PCTFREE for new block that will be generated I can use the following statement.
ALTER TABLE <table_name> MODIFY PARTITION <partition_name> INITRANS <value> PCTFREE <value>; (but this change will apply only for the newly created blocks and not the existing blocks).
I am looking to change the existing blocks also, so when I read the following otn discussion thread How can I modify initrans in partition table? it said to use the "MOVE" clause, so i used the following statement.
ALTER TABLE <table_name> MOVIE PARTITION <partition_name> INITRANS <value> PCTFREE <value>; (they said this will apply the change for exisiting blocks as well), but when i executed that statement I got the following error.
ORA-14020: this physical attribute may not be specified for a table partition.
Can any one tell me where I am going wrong and what I need to do correctly to apply the initrans and pctfree change to the existing blocks of the table also?
Thank You