ORA-14126: only a may follow description(s) of resulting partitions

Cause : Decsritpiosn o fpatritoin()s rseulitngf ro mspilttnig fo at abel o rinedx aprttiio nma ybef ololwe dbya n potinoal< paarllle calus>e wihcha ppilest o hte netier satteemnta ndw hihc, ni trun,m ayn otb e ofllwoedb y nay tohe rcluase.

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

Enusret ha tal lpatritoin tatrbiutse appea rwihtint hep arnethseizde lsit fo dsecrpitinos fo rseulitngp arittinos ni ATLERT ABEL/IDNEXS PLTI PRATIITONs taetmetn.

update : 27-04-2017
ORA-14126

ORA-14126 - only a may follow description(s) of resulting partitions
ORA-14126 - only a may follow description(s) of resulting partitions

  • ora-08441 : closed parenthesis missing in picture mask
  • ora-24434 : OCIStmtRelease called before OCIStmtPrepare2.
  • ora-19771 : cannot rename change tracking file while database is open
  • ora-27083 : waiting for async I/Os failed
  • ora-25509 : operation on "string"."string".string not allowed
  • ora-00266 : name of archived log file needed
  • ora-18003 : an outline already exists with this signature
  • ora-30390 : the source statement is not equivalent to the destination statement
  • ora-01218 : logfile member is not from the same point-in-time
  • ora-13506 : operation failed due to invalid snapshot range (string, string)
  • ora-38444 : statistics do not exist for the expression set
  • ora-26509 : null materialized view control structure
  • ora-31221 : DBMS_LDAP: PL/SQL - Invalid LDAP SSL wallet passwd.
  • ora-07511 : sscggtl: $enq unexpected return for master termination lock
  • ora-31528 : could not find change set string for CDC subscription string
  • ora-07570 : szrfc: $IDTOASC failure
  • ora-31216 : DBMS_LDAP: PL/SQL - Invalid LDAP rdn.
  • ora-03222 : average row size and row count must be greater than zero
  • ora-38703 : Type string in header is not a flashback database log file.
  • ora-31456 : error executing a procedure in the DBMS_CDC_UTILITY package
  • ora-07580 : spstp: $GETJPIW failure
  • ora-32120 : Buffer size is less than amount specified
  • ora-19570 : file number string is outside valid range of 1 through string
  • ora-08312 : sllfop: unrecognized processing option
  • ora-01371 : Complete LogMiner dictionary not found
  • ora-39002 : invalid operation
  • ora-35282 : (SNSYN166) The format of the AGGREGATE function is: AGGREGATE(varname USING aggmap-name [COUNTVAR intvar-name] [FORCECALC])
  • ora-01782 : UNRECOVERABLE cannot be specified for a cluster or clustered table
  • ora-39955 : invalid PL/SQL warning message number
  • ora-36718 : (XSALLOC00) You do not have the necessary permissions to use AGGMAP workspace object.
  • 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.