SQL & PL/SQL

Hi,

When I am trying to execute an update statement where i am tring to update date values emp_det from 11-oct-2010 to 12-nov-2010.

Oracle throws an error :

ORA-14402
updating partition key column would cause a partition change

I think that this is because emp_det is a partitioning key of a partitioned table.

Oracle documentation says that

"UPDATE will fail if you change a value in the column that would move the
row to a different partition or subpartition, unless you enable row
movement" .

alter table t enable row movement;

I did not understand what is meant by "enable row movement".

I cannot drop the partitions and recreate it after updating the table and also i don't have proper priviliges for enale row movement syntax
because of the lack of privileges. How to solve this is issues with out row movement and recreate partition.


Can this be done by a developer or is there any other way to execute update in this case? its urgent.. pls help..

thanks in advance..

By
Sivaraman

Edited by: kn_sivaraman on Nov 1, 2010 2:32 AM