Home / dating rpg game / Ora 14402 updating partition

Ora 14402 updating partition

Can anybody please suggest any alternative to update the row.One of the relatively newer features in Oracle concerns the moving of rows.SQL All of the cities are located in the Denver area (city ID of 282 in this example).Broomfield is further north of the Denver metro area and has been slated to become part of the Boulder area office group (using a city ID of 283).

ora 14402 updating partition-75ora 14402 updating partition-24

Furthermore, by “move,” what exactly does move mean?PARTITION_NAME LAST_ANALYZED NUM_ROWS BLOCKS SAMPLE_SIZE HIGH_VALUE PORTAL_SERVICE_1 12/8/2016 41 1 PORTAL_SERVICE_2 6/8/2016 44 2 PORTAL_SERVICE_3 10/8/2016 29602 2014 29602 3 PORTAL_SERVICE_OTHERS 24/5/2016 0 110 DEFAULT i get error: Error report - SQL Error: ORA-14402: updating partition key column would cause a partition change 14402.00000 - "updating partition key column would cause a partition change" i am not allowed to use Enable Row Movement.Many partitioned table examples use regions, cities and states as list examples.What happens if you use a city as a partition key and an office in that city moves elsewhere?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 [email protected] ~]$ oerr ora 1440214402, 00000, "updating partition key column would cause a partition change"// *Cause: An UPDATE statement attempted to change the value of a partition // key column causing migration of the row to another partition// *Action: Do not attempt to update a partition key column or make sure that// the new partition key is within the range containing the old// partition key.PROBLEM: update XXUSER.abc_table set id=102 where a_id=930000000428682 Error at line 6 ORA-14402: updating partition key column would cause a partition change SOLUTION: new value is outside the range of the existing partition when updated partition 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".

262 comments

  1. Partition means you are physically storing the data on different location based on Partition Key. So when you want to update the partition key you need to move the.

Leave a Reply

Your email address will not be published. Required fields are marked *

*