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 : 23-08-2017

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

  • ora-25008 : no implicit conversion to LOB datatype in instead-of trigger
  • ora-38445 : TOP clause not allowed with no statistics
  • ora-06556 : the pipe is empty, cannot fulfill the unpack_message request
  • ora-01944 : IDENTIFIED EXTERNALLY already specified
  • ora-22294 : cannot update a LOB opened in read-only mode
  • ora-12504 : TNS:listener was not given the SID in CONNECT_DATA
  • ora-22166 : collection is empty
  • ora-24379 : invalid user callback type
  • ora-28232 : invalid input length for obfuscation toolkit
  • ora-02089 : COMMIT is not allowed in a subordinate session
  • ora-13858 : Invalid action name
  • ora-13913 : The threshold cannot be set when SYSAUX is offline.
  • ora-25248 : duplicate agent specified in the agent list
  • ora-00609 : could not attach to incoming connection
  • ora-09949 : Unable to get client operating system privileges
  • ora-03261 : the tablespace string has only one file
  • ora-00256 : cannot translate archive destination string string
  • ora-13112 : cannot delete topo_geometry layer [string] from topology
  • ora-32624 : illegal reordering of MODEL dimensions
  • ora-39208 : Parameter string is invalid for string jobs.
  • ora-16195 : DG_CONFIG requires DB_UNIQUE_NAME be explicitly defined
  • ora-30767 : OID type mismatch
  • ora-07268 : szguns: getpwuid error.
  • ora-25155 : column used in NATURAL join cannot have qualifier
  • ora-32152 : Cannot perform operation on a null number
  • ora-25444 : invalid ROWID: string for table alias: string
  • ora-09908 : slkmnm: gethostname returned error code.
  • ora-01268 : invalid TEMPFILE clause for alter of permanent TABLESPACE
  • ora-30927 : Unable to complete execution due to failure in temporary table transformation
  • 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.