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 : 24-06-2017
ORA-14174

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

  • ora-09989 : attempt to use invalid skgmsdef struct pointer
  • ora-19372 : invalid update condition
  • ora-31605 : the following was returned from string in routine string: LPX-number: string
  • ora-14022 : creation of LOCAL partitioned cluster indices is not supported
  • ora-02262 : ORA-string occurs while type-checking column default value expression
  • ora-27101 : shared memory realm does not exist
  • ora-15052 : ASM file name 'string' is not in diskgroup "string"
  • ora-33447 : (ESDREAD16) Discarding compiled code for workspace object because workspace object and workspace object, which were partition-dependent when the code was compiled, are now not partition-dependent.
  • ora-30979 : Partitioned XML Index not yet supported.
  • ora-06128 : NETTCP: unable to create mailbox
  • ora-36402 : (XSSPROP03) The property '$string' requires a leading "$" because it is a system-reserved property name.
  • ora-28365 : wallet is not open
  • ora-06408 : NETCMN: incorrect message format
  • ora-25467 : table alias not specified
  • ora-01243 : system tablespace file suffered media failure
  • ora-27028 : skgfqcre: sbtbackup returned error
  • ora-29521 : referenced name string could not be found
  • ora-28544 : connect to agent failed, probable Net8 administration error
  • ora-39601 : Hash key is required.
  • ora-36708 : (XSMXALLOC00) Variable workspace object must be dimensioned to be used by the ALLOCATE command.
  • ora-07630 : smpdal: $DELTVA failure
  • ora-09778 : snynfyport: failure allocating the notify port.
  • ora-01262 : Stat failed on a file destination directory
  • ora-02149 : Specified partition does not exist
  • ora-28011 : the account will expire soon; change your password now
  • ora-00366 : log string of thread string, checksum error in the file header
  • ora-02379 : profile string already exists
  • ora-30388 : name of the rewrite equivalence is not specified
  • ora-19011 : Character string buffer too small
  • ora-38788 : More standby database recovery is needed
  • 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.