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

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

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

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

update : 25-04-2017
ORA-14083

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

  • ora-26736 : Data Pump error
  • ora-02722 : osnpui: cannot send break message to orapop
  • ora-32588 : supplemental logging attribute string exists
  • ora-39155 : error expanding dump file name "string"
  • ora-13610 : The directive string does not exist for task string.
  • ora-14084 : you may specify TABLESPACE DEFAULT only for a LOCAL index
  • ora-12350 : database link being dropped is still mounted
  • ora-16736 : unable to find the destination entry of standby database "string" in V$ARCHIVE_DEST
  • ora-39002 : invalid operation
  • ora-34350 : (MXDSS06) string is an open analytic workspace.
  • ora-23365 : site string does not exist
  • ora-24386 : statement/server handle is in use when being freed
  • ora-32121 : Source FILE is null
  • ora-02777 : Stat failed on log directory
  • ora-29658 : EXTERNAL NAME clause is not compatible with its supertype
  • ora-36181 : A VARIABLE cannot have both the $AGGREGATE_FROM and $AGGREGATE_FROMVAR properties applied to it.
  • ora-16101 : a valid start SCN could not be found
  • ora-09872 : TASDEF_CREATE: create failure in creating ?/dbs/tasdef@.dbf.
  • ora-27062 : could not find pending async I/Os
  • ora-12171 : TNS:could not resolve connect identifier: string
  • ora-15048 : ASM internal files cannot be deleted
  • ora-32824 : schedule exists for source string and destination string
  • ora-38780 : Restore point 'string' does not exist.
  • ora-28670 : mapping table cannot be dropped due to an existing bitmap index
  • ora-39771 : stream must be loaded before its handle is freed
  • ora-29555 : Java source, class or resource is not allowed here
  • ora-01532 : cannot create database; instance being started elsewhere
  • ora-29904 : error in executing ODCIIndexClose() routine
  • ora-07406 : slbtpd: invalid number.
  • ora-00155 : cannot perform work outside of global transaction
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.