Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-14402: updating partition key column would cause a
partition change
- 2 Answers
- 10446 Views
- I also Faced
- E-Mail Answers
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 |
PCC-00137: Invalid use of SQL cursor host variable
ORA-12451: label not designated as USER or DATA
ORA-29286: internal error
ORA-29854: keyword BITMAP may not be used in creating domain indexes
NID-00111: Oracle error reported from target database while executing string string
RMAN-08591: WARNING: invalid archivelog deletion policy
RMAN-06563: controlfile or SPFILE must be restored using FROM AUTOBACKUP
ORA-22925: operation would exceed maximum size allowed for a LOB value
ORA-29255: Cursor contains both bind and define arrays which is not permissible
ORA-14276: EXCHANGE SUBPARTITION requires a non-partitioned, non-clustered table
ORA-36716: (XSMXALLOC04) You can only use the ACROSS phrase when allocation BASIS workspace object is a FORMULA.
ORA-01216: thread string is expected to be disabled after CREATE CONTROLFILE
Oracle Errors 
