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 : 29-06-2017

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

  • ora-32817 : message system link string is not configured with a log queue for string
  • ora-16546 : missing or invalid piece
  • ora-02834 : Server unable to open file
  • ora-31053 : The value of the depth argument in the operator cannot be negative
  • ora-27017 : skgfcls: media handle returned by sbtinfo exceeds max length(SSTMXQMH)
  • ora-13237 : internal error during R-tree concurrent updates: [string]
  • ora-13183 : unsupported geometric type for geometry string.string
  • ora-13231 : failed to create index table [string] during R-tree creation
  • ora-31419 : source table string does not exist
  • ora-13620 : The task or object string is read-only and cannot be deleted or modified.
  • ora-19017 : Attributes can only be simple scalars
  • ora-10700 : Alter access violation exception handler
  • ora-12092 : cannot online redefine replicated table "string"."string"
  • ora-14646 : Specified alter table operation involving compression cannot be performed in the presence of usable bitmap indexes
  • ora-27061 : waiting for async I/Os failed
  • ora-31442 : operation timed out while acquiring lock on string
  • ora-16951 : Too many bind variables supplied for this SQL statement.
  • ora-01273 : STANDBY_FILE_MANAGEMENT = AUTO needs COMPATIBLE = string or higher
  • ora-00965 : column aliases not allowed for '*'
  • ora-32604 : invalid REBUILD option
  • ora-13503 : Creating SYSAUX tablespace with invalid attributes
  • ora-38766 : cannot flashback data file string; file resized smaller
  • ora-22803 : object type contains zero attributes
  • ora-04010 : the number of values to CACHE must be greater than 1
  • ora-32824 : schedule exists for source string and destination string
  • ora-08322 : scnmin: open/convert of bias lock failed
  • ora-30343 : level name is not unique within this dimension
  • ora-26764 : invalid parameter "string" for local capture "string"
  • ora-01697 : control file is for a clone database
  • ora-12473 : The procedure is disabled when Label Security is used with OID.
  • 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.