ORA-14174: only a may follow COALESCE PARTITION|SUBPARTITION

Cause : LAET RATLB EOCLASEECP RAITITNOS|BUAPTRTIOI Nam yebf loolew dyba npoitnola< aparlllec alsu>e .oNp raititnos/buaptrtioi ntartbitusem yab epscefieid

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

nEusert ah tonp raititnos/buaptrtioi ntartbitu eaw spscefiei.d

update : 19-08-2017
ORA-14174

ORA-14174 - only a may follow COALESCE PARTITION|SUBPARTITION
ORA-14174 - only a may follow COALESCE PARTITION|SUBPARTITION

  • ora-29308 : view TS_PITR_CHECK failure
  • ora-22875 : cannot drop primary key of an object table whose object identifier is primary key based
  • ora-10261 : Limit the size of the PGA heap
  • ora-32500 : Dirname 'string' cannot exceed 'number' characters
  • ora-24371 : data would not fit in current prefetch buffer
  • ora-31505 : cannot alter or drop predefined change set
  • ora-36276 : (XSCGMDLAGG06) The current operator does not need a weight variable.
  • ora-13370 : failure in applying 3D LRS functions
  • ora-12021 : materialized view "string"."string" is corrupt
  • ora-01676 : standby file name convert of 'string' exceeds maximum length of string
  • ora-14054 : invalid ALTER TABLE TRUNCATE PARTITION option
  • ora-13150 : failed to insert exception record
  • ora-24183 : invalid transformation
  • ora-19117 : invalid redefinition of predefined namespace prefix 'string'
  • ora-14500 : LOCAL option not valid without partition name
  • ora-36270 : (XSCGMDLAGG03) The parameter list for the AGGREGATION function includes duplicate values.
  • ora-06812 : TLI Driver: could not read the ethernet driver's node address
  • ora-32019 : The parameter SPFILE cannot be updated in the server parameter file.
  • ora-15108 : missing or invalid template name
  • ora-29508 : query derived from USING clause did not select a value of type string
  • ora-06130 : NETTCP: host access denied
  • ora-38776 : cannot begin flashback generation - flash recovery area is disabled
  • ora-31492 : could not set session parameters for LogMiner session
  • ora-06922 : CMX: bad write length
  • ora-01230 : cannot make read only - file string is offline
  • ora-38786 : Flash recovery area is not enabled.
  • ora-06720 : TLI Driver: SID lookup failure
  • ora-39167 : Tablespace string was not found.
  • ora-32505 : too many watchpoints
  • ora-31661 : there are no metadata transform values of type VARCHAR2
  • 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.