I cannot reproduce, works as supposed for me...What version are you on ?
1 create table t (x number, y char(10))
2 partition by range (x) (
3 partition p1 values less than (100),
4 partition p2 values less than (maxvalue)
5* )
test@CENTRAL> /
Table created.
test@CENTRAL> select table_name, row_movement from user_tables where table_name='T';
TABLE_NAME ROW_MOVE
------------------------------ --------
T DISABLED
test@CENTRAL>
test@CENTRAL> insert into t values (10,'a');
1 row created.
test@CENTRAL> commit;
Commit complete.
test@CENTRAL> update t set x = 110 ;
update t set x = 110
*
ERROR at line 1:
ORA-14402: updating partition key column would cause a partition change
test@CENTRAL> alter table t enable row movement;
Table altered.
test@CENTRAL> update t set x = 110 ;
1 row updated.
test@CENTRAL> commit;
Commit complete.
test@CENTRAL> alter table t disable row movement;
Table altered.
test@CENTRAL> select table_name, row_movement from user_tables where table_name='T';
TABLE_NAME ROW_MOVE
------------------------------ --------
T DISABLED
test@CENTRAL> update t set x = 10;
update t set x = 10
*
ERROR at line 1:
ORA-14402: updating partition key column would cause a partition change
test@CENTRAL>
Stefan
On 5/2/06, hamid alavi
<alavihamid@gmail.com> wrote:
List,
I have partition table and I did alter table table_name enable
rowmovement, then when I try to Disable row movement still when I
update the partition key the record updated means the disable does not
work & I can not disable row movement afte enableing it, any idea?
--
Hamid Alavi
(C) 818-416-5095
(F) 206-338-2375