Update Partition Key Oracle

Hello all, i am using oracle 11gr2 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.. The partitioning key consists of one or more columns that determine the partition where each row is stored. oracle automatically directs insert, update, and delete operations to the appropriate partition with the partitioning key.. Partitioning key. each row in a partitioned table is unambiguously assigned to a single partition. the partitioning key is comprised of one or more columns that determine the partition where each row will be stored. oracle automatically directs insert, update, and delete operations to the appropriate partition through the use of the.

Arch anywhere - an easy way to install a fully custom arch

As far back as oracle 8.1.5 documentation, row movement applied to updatable partition keys. a list partition where the partition key is a specific value is a good example of this. many partitioned table examples use regions, cities and states as list examples.. Update cdr_data cdt set a = 'b' where ab = 'c' potentially with a parallel hint that would allow oracle to update multiple partitions in parallel. if you really, really want to update each partition independently, it would make much more sense to do so based on the partition keys. for example, if your table has daily partitions based on a date. And then the rowid changes, internally we process the update of a partition key that causes the partition to change as a delete+insert (but we only fire an update trigger). so, all indexes are naturally maintained - since we delete the row and then insert it into the new partition..

update partition key oracle

visit link reference