ALTER TABLE RECEIVED_DOCUMENTS
ADD PARTITION EES_COUNTRIES VALUES('NORWAY','ICELAND')
Result:ERROR at line 1: ORA-14323: cannot add partition when DEFAULT partition exists
Solution: split the overflow partition:
ALTER TABLE RECEIVED_DOCUMENTS
SPLIT PARTITION "OTHERS"
VALUES ('NORWAY','ICELAND')
INTO ( PARTITION EES_COUNTRIES,
PARTITION OTHERS
)
UPDATE INDEXES;
No comments:
Post a Comment