Oracle DBA, How To, Error, Cause and Action

ORA-14626: values being added already exist in DEFAULT subpartition

ORA-14626: values being added already exist in DEFAULT subpartition


Cause:


An ADD VALUE operation cannot be executed because the values being added exist in the DEFAULT subpartition



Action:


Issue a SPLIT of the DEFAULT subpartition and then MERGE the split subpartition into the subpartition to which values need to be added

No comments:

Post a Comment

Thanks for your comment.

Subscribe to: Post Comments (Atom)