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

advertisements

_____________________________________________________________________________________________________________________

The Eucharistic Miracles of the World
Error Description:
Application is getting following error while accessing the partitioned table.
The SQL Exception is: "ORA-14402: updating partition key column would cause a partition change
Normally this error happens after making the partitions to the tables.
Solution Description:
Find out the partitioned tables involved for the particular operation from the application and enable the row movement for those tables which will resolve your issue.

SQL> select table_name, row_movement, partitioned from dba_tables where table_name='PROB_DATA';

TABLE_NAME                     ROW_MOVE PAR
------------------------------ -------- ---
PROB_DATA                      DISABLED NO
SQL> alter table PROB_DATA enable row movement;

Table altered.

_____________________________________________________________________________________________________________________

Website Stats

0 comments:

Post a Comment

Labels

Oracle (629) Script (86) General (77) Unix (47) Blog (23) Technology (19) gadget (6) games (6) Business (3) OCI (3) SQL* Loader (3) Datapump (2)
 

acehints.com Copyright 2011-23 All Rights Reserved | Site Map | Contact | Disclaimer