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

_____________________________________________________________________________________________________________________

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 (580) General (60) Unix (47) Script (41) Blog (23) OCI (3) SQL* Loader (3) Datapump (2) Software (1)
DBA Tips
 

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