ORA-14031: partitioning column may not be of type LONG or LONG RAW

Cause : Partitioning column specified by the user was of type LONG or LONG RAW, which is illegal.

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

Ensure that no partitioning column is of type LONG or LONG RAW.

update : 25-04-2017
ORA-14031

ORA-14031 - partitioning column may not be of type LONG or LONG RAW
ORA-14031 - partitioning column may not be of type LONG or LONG RAW

  • ora-27303 : additional information: string
  • ora-02254 : DEFAULT not allowed here
  • ora-15190 : Internal ASM testing event number 15190
  • ora-36831 : (XSLMGEN01) View token cannot be NA
  • ora-25302 : Operation not possible for non-buffered queue string
  • ora-07504 : scgcmn: $hiber unexpected return
  • ora-00826 : cannot set sga_target for an ASM instance
  • ora-34357 : (MXDSS10) string is not an alias of analytic workspace string.
  • ora-32587 : Cannot drop nonexistent string supplemental logging
  • ora-24012 : cannot drop QUEUE_TABLE, some queues in string have not been dropped
  • ora-02213 : duplicate PCTUSED option specification
  • ora-07587 : spdcr: $CREPRC failure
  • ora-36224 : (XSLPDSC05) workspace object is not a loop dimension
  • ora-25210 : invalid value for RELATIVE_MSGID, no message in queue with that msgid
  • ora-00101 : invalid specification for system parameter DISPATCHERS
  • ora-13190 : recursive SQL fetch failed
  • ora-27377 : windows cannot have event based schedules
  • ora-10619 : Avoid assertions when possible
  • ora-16723 : setting AlternateLocation property conflicts with the redo transport setting
  • ora-19730 : can not convert offline plugged-in datafile string
  • ora-32737 : Hang analysis aborted due to failed memory allocation
  • ora-29968 : No primary operator bindings found for ancillary binding #string
  • ora-14640 : add/coalesce index partition operation is valid only for hash partitioned global indexes
  • ora-02151 : invalid tablespace name: string
  • ora-06105 : NETTCP: remote host is unknown
  • ora-04073 : column list not valid for this trigger type
  • ora-22900 : the SELECT list item of THE subquery is not a collection type
  • ora-07418 : sfareq: Database writer got error in timing function.
  • ora-30957 : cannot downgrade because there are XML indexes
  • ora-12687 : Credentials expired.
  • 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.