Oracle DBA, How To, Error, Cause and Action

ORA-14324: values being added already exist in DEFAULT partition

ORA-14324: values being added already exist in DEFAULT partition


Cause:


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



Action:


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

No comments:

Post a Comment

Thanks for your comment.