ORA-14323: cannot add partition when DEFAULT partition exists



ORA-14323: cannot add partition when DEFAULT partition exists..

Answer / guest

Cause: An ADD PARTITION operation cannot be executed when a
partition with DEFAULT values exists

Action: Issue a SPLIT of the DEFAULT partition instead

Please add more information about this Error

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

ORA-30013: undo tablespace 'string' is currently in use

1 Answers  


ORA-01111: name for data file string is unknown - rename to correct file

1 Answers  


ORA-30338: illegal dimension hierachy name

1 Answers  


ORA-25466: data not specified for variable name: string

1 Answers  


ORA-02436: date or system variable wrongly specified in CHECK constraint

1 Answers  






ORA-07606: szprv: $CHKPRO failure

1 Answers  


LPX-00662: Invalid encoding.

1 Answers  


RMAN-08541: channel string: SPFILE restore from autobackup complete

1 Answers  


LCD-00215: parameter files nested too deep [string]

1 Answers  


PLS-00155: Only a function may be a MAP, ORDER or CONSTRUCTOR method.

1 Answers  


ORA-01783: only one RECOVERABLE or UNRECOVERABLE clause may be specified

1 Answers  


ORA-32161: Cannot perform piecewise fetch

1 Answers  


Categories