Oracle Database Discussions

Hello All,

I am using Oracle 11gR2 (11.2.0.3).

I have a table that is partitioned by range based on one column as below:

create table test_partition (p_id number(10), p_date date)
PARTITION BY RANGE (p_date)
INTERVAL (NUMTODSINTERVAL(1,'DAY'))
(
   PARTITION part_01 values LESS THAN (TO_DATE('18-MAR-2012','DD-MON-YYYY'))
);

whenever i insert a new date on p_date a new partition is created as below

insert into test_partition VALUES (1, sysdate-1);

I am getting "ORA-14402: updating partition key column would cause a partition change" whenever I update the p_date column as below:

update test_partition set p_date = sysdate;

i can solve this problem by enable row movement on this table.

My question, enabling row movement, does it have any negative impact on the table? performance/storage ....?
Can i keep enabling row movement on this table ? whenever this table exists and for all transactions? since I do not know when my application update the p_date column

Edited by: NB on Jun 2, 2012 8:08 PM