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

ORA-14281: CHECK constraint mismatch in ALTER TABLE EXCHANGE SUBPARTITION

1 Answers  


ORA-30106: reserved for future use

1 Answers  


SQL*Loader-00287: No control file name specified.

1 Answers  


ORA-13285: Geometry coordinate transformation error

1 Answers  


ORA-25408: can not safely replay call

2 Answers  


QSM-02049: subquery using the ANY clause in mv

1 Answers  


IMP-00010: not a valid export file, header failed verification

1 Answers  


ORA-02053: transaction string committed, some remote DBs may be in-doubt

1 Answers  


ORA-09806: Allocation of label string buffer failed.

1 Answers  


ORA-25242: cannot change subscriber name from string to string without FIRST_MESSAGE option

1 Answers  


ORA-02334: cannot infer type for column

1 Answers  


ORA-38417: attribute set string does not exist

1 Answers  


Categories