ORA-14083: cannot drop the only partition of a partitioned table



ORA-14083: cannot drop the only partition of a partitioned table..

Answer / guest

Cause: A drop partition command is being executed when there
is only one partition in the table

Action: Ensure that there is at least one partition. Drop
table to remove all partitions

Please add more information about this Error

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

PCC-00062: Must use option SQLCHECK=SEMANTICS(FULL) when there is embedded PL/SQL

1 Answers  


LSX-00163: duplicated content specification in "~S"

1 Answers  


ORA-13055: Oracle object string does not exist in specified table

1 Answers  


EXP-00024: Export views not installed, please notify your DBA

1 Answers  


ORA-33076: (XSAGDNGL37) In AGGMAP workspace object, the value 'number' is not a valid value of dimension workspace object.

1 Answers  






ORA-24077: cannot create propagation schedule for EXCEPTION queue string.string

1 Answers  


RMAN-06193: connected to target database (not started)

3 Answers  


ORA-12234: TNS:Redirect to destination

1 Answers  


KUP-04021: field formatting error for field string

1 Answers  


ORA-01129: user's default or temporary tablespace does not exist

1 Answers  


PLS-00505: User Defined Types may only be defined as PLSQL Tables or Records

1 Answers  


ORA-19200: Invalid column specification

1 Answers  


Categories