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 : 30-04-2017
ORA-14174

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

  • ora-02095 : specified initialization parameter cannot be modified
  • ora-29893 : indextypes without column data do not need the given data type
  • ora-12354 : secondary object being dropped
  • ora-24816 : Expanded non LONG bind data supplied after actual LONG or LOB column
  • ora-30974 : invalid Path Id Index option for XML Index
  • ora-16198 : Timeout incurred on internal channel during remote archival
  • ora-32152 : Cannot perform operation on a null number
  • ora-16774 : error stopping Redo Apply
  • ora-09890 : osnTXtt: malloc failed
  • ora-31187 : Cannot Add Node 'string' (type='string') to Simple Type Node 'string'
  • ora-24203 : operation failed, queue table string.string has errors
  • ora-00484 : LMS* process terminated with error
  • ora-31060 : Resource at path string could not be deleted
  • ora-01262 : Stat failed on a file destination directory
  • ora-39961 : message specified was not found
  • ora-16752 : resource guard could not mount standby database
  • ora-36882 : (XSSRF01) The second parameter of an AW single row function cannot be NULL.
  • ora-00042 : Unknown Service name string
  • ora-30744 : "string" is not an object table
  • ora-10564 : tablespace string
  • ora-16772 : error switching over between primary and standby databases
  • ora-31226 : DBMS_LDAP: MOD_ARRAY size limit exceeded
  • ora-29270 : too many open HTTP requests
  • ora-39147 : cannot migrate Data Pump queue table ownership to this instance
  • ora-32026 : %s.string has fewer columns compared to string table.
  • ora-39141 : dump file "string" is a duplicate of dump file "string"
  • ora-02805 : Unable to set handler for SIGTPA
  • ora-08182 : operation not supported while in Flashback mode
  • ora-07658 : slsprom:$QIOW read failure
  • ora-39958 : invalid warning category qualifier
  • 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.