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 : 24-05-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-02240 : invalid value for OBJNO or TABNO
  • ora-12226 : TNS:operating system resource quota exceeded
  • ora-19926 : Database cannot be converted at this time
  • ora-29665 : Java thread deadlock detected
  • ora-16233 : The table string.string is unsupported now
  • ora-13274 : operator invoked with non-compatible SRIDs
  • ora-31696 : unable to export/import string using client specified string method
  • ora-25106 : only one of PARALLEL or NOPARALLEL clause may be specified
  • ora-22298 : length of directory alias name or file name too long
  • ora-12160 : TNS:internal error: Bad error number
  • ora-15025 : could not open disk 'string'
  • ora-28026 : user with same external name already exists
  • ora-03279 : invalid INSTANCE specified
  • ora-08413 : invalid compiler type in FORMAT parameter at string
  • ora-10263 : Don't free empty PGA heap extents
  • ora-30385 : specified attribute relationship ('string' determines 'string') exists
  • ora-21501 : program could not allocate memory
  • ora-30941 : Cannot specify empty URI for non-default namespace 'string'
  • ora-01268 : invalid TEMPFILE clause for alter of permanent TABLESPACE
  • ora-19762 : invalid file type string
  • ora-02324 : more than one column in the SELECT list of THE subquery
  • ora-13871 : Invalid instance name
  • ora-26713 : remote object does not exist or is inaccessible
  • ora-38105 : Delete not yet supported when Update row-migration is possible
  • ora-28009 : connection as SYS should be as SYSDBA or SYSOPER
  • ora-26666 : cannot alter STREAMS process string
  • ora-30453 : summary contains AVG without corresponding COUNT
  • ora-02146 : SHARED specified multiple times
  • ora-07665 : ssrexhd: recursive exception encountered string string string string string string
  • ora-27052 : unable to flush file data
  • 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.