ORA-14286: cannot COALESCE the only subpartition of this table partition

Cause : A COALSECE SUBAPRTITIO Ncomman dwas isused whe nthere si only noe subpratitioni n the aprtitio nwhich si illegla

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

Ensuret hat three is a tleast noe subpratition .Drop pratitiont o remoev all sbupartitoins.

update : 27-06-2017

ORA-14286 - cannot COALESCE the only subpartition of this table partition
ORA-14286 - cannot COALESCE the only subpartition of this table partition

  • ora-08266 : create_ora_addr: cannot register name in nameserver
  • ora-32054 : lost communication with FMPUTL process
  • ora-02306 : cannot create a type that already has valid dependent(s)
  • ora-30375 : materialized view cannot be considered fresh
  • ora-25958 : join index where clause predicate may only contain column references
  • ora-32130 : invalid offset/index refrenced in Bytes
  • ora-23441 : object does not exist for refresh group template
  • ora-27080 : too many files open
  • ora-15115 : missing or invalid ASM disk size specifier
  • ora-09789 : sllfsk: unable to read file.
  • ora-22629 : OCIAnyData is null
  • ora-21601 : attribute is not an object
  • ora-01195 : online backup of file string needs more recovery to be consistent
  • ora-01158 : database string already mounted
  • ora-10574 : Test recovery did not corrupt any data block
  • ora-39029 : worker string with process name "string" prematurely terminated
  • ora-16075 : standby database destination mismatch
  • ora-28576 : lost RPC connection to external procedure agent
  • ora-00832 : no streams pool created and cannot automatically create one
  • ora-16571 : Data Guard configuration file creation failure
  • ora-32591 : connect string too long
  • ora-30350 : specified dimension attribute does not exist
  • ora-30181 : integer in argument index is not immediately followed by )
  • ora-33006 : (XSAGDNGL02) The relation workspace object is not related to itself.
  • ora-10261 : Limit the size of the PGA heap
  • ora-39120 : Table string can't be truncated, data will be skipped. Failing error is: string
  • ora-24905 : invalid recepient protocol attribute passed into OCI call
  • ora-14001 : LOCAL clause contradicts previosly specified GLOBAL clause
  • ora-27377 : windows cannot have event based schedules
  • ora-07512 : sscggtl: $enq unexpected return for client termination lock
  • 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.