ORA-14402: updating partition key column would cause a
partition change
Answers were Sorted based on User's Feedback
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 |
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 |
ORA-03235: max # extents (string) reached in table string.string subpartition string
ORA-19005: Duplicate XMLType LOB storage option
ORA-30754: column or table string stores objects of only one type
LPX-00201: unknown encoding "~s"
ORA-37021: (XSMULTI02) Object workspace object is not acquired.
DRG-50917: escape on at end of text query string
LPX-00238: unterminated conditional section
ORA-26502: error resignal
PLS-00374: illegal EXIT statement; it must appear inside the loop labeled 'string'
ORA-30046: Undo tablespace string not found in controlfile.
DRG-12803: invalid text datatype
ORA-30930: NOCYCLE keyword is required with CONNECT_BY_ISCYCLE pseudocolumn