Re: enable row movement

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_at_CENTRAL> /

Table created.

test_at_CENTRAL> select table_name, row_movement from user_tables where table_name='T';

TABLE_NAME                     ROW_MOVE
------------------------------ --------
T                              DISABLED

test_at_CENTRAL>
test_at_CENTRAL> insert into t values (10,'a');

1 row created.

test_at_CENTRAL> commit;

Commit complete.

test_at_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_at_CENTRAL> alter table t enable row movement;

Table altered.

test_at_CENTRAL> update t set x = 110 ;

1 row updated.

test_at_CENTRAL> commit;

Commit complete.

test_at_CENTRAL> alter table t disable row movement;

Table altered.

test_at_CENTRAL> select table_name, row_movement from user_tables where table_name='T';

TABLE_NAME                     ROW_MOVE
------------------------------ --------
T                              DISABLED

test_at_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_at_CENTRAL>

Stefan

On 5/2/06, hamid alavi <alavihamid_at_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
>

--
http://www.freelists.org/webpage/oracle-l