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

Answers were Sorted based on User's Feedback



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

Answer / virender sharma

alter table <partition name> enable row movement;

after that fire update command it will allow update

Is This Answer Correct ?    5 Yes 0 No

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

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-03235: max # extents (string) reached in table string.string subpartition string

1 Answers  


ORA-19005: Duplicate XMLType LOB storage option

1 Answers  


ORA-30754: column or table string stores objects of only one type

1 Answers  


LPX-00201: unknown encoding "~s"

1 Answers  


ORA-37021: (XSMULTI02) Object workspace object is not acquired.

1 Answers  






DRG-50917: escape on at end of text query string

1 Answers  


LPX-00238: unterminated conditional section

1 Answers  


ORA-26502: error resignal

1 Answers  


PLS-00374: illegal EXIT statement; it must appear inside the loop labeled 'string'

1 Answers  


ORA-30046: Undo tablespace string not found in controlfile.

1 Answers  


DRG-12803: invalid text datatype

1 Answers  


ORA-30930: NOCYCLE keyword is required with CONNECT_BY_ISCYCLE pseudocolumn

1 Answers  


Categories