ORA-14621: cannot add subpartition when DEFAULT subpartition
exists



ORA-14621: cannot add subpartition when DEFAULT subpartition exists..

Answer / guest

Cause: An ADD SUBPARTITION operation cannot be executed when
a subpartition with DEFAULT values exists

Action: Issue a SPLIT of the DEFAULT subpartition instead

Please add more information about this Error

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

DRG-11106: user database session has terminated during this operation

1 Answers  


ORA-00077: dump string is not valid

1 Answers  


ORA-25115: duplicate BLOCK option specification

1 Answers  


ORA-38412: Expression set column string does not exist.

1 Answers  


TNS-12628: TNS:no event callbacks

1 Answers  






KUP-04015: internal SLF error

1 Answers  


ORA-02259: duplicate UNIQUE/PRIMARY KEY specifications

1 Answers  


KUP-04039: unexpected error while trying to find file string in string

1 Answers  


ORA-30176: invalid format code used in the format string

1 Answers  


ORA-16721: unable to set LOG_ARCHIVE_DEST_n parameters

1 Answers  


TNS-00147: Failed to start a pre-spawned pump.

1 Answers  


ORA-37070: You may not execute OLAP DML programs in a parallel query session.

1 Answers  


Categories