Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » oracle l »

Re: enable row movement

Stefan Knecht

2006-05-03

Replies:

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

©2008 dba.5341.com - Jax Systems, LLC, U.S.A.