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-09-2017

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-01061 : cannot start up a V8 server using a V7 client application
  • ora-37114 : OLAP API bootstrap error: (string)
  • ora-40304 : invalid classname string in prior probability specification
  • ora-07449 : sc: usnewlock failed.
  • ora-15008 : cannot drop system template
  • ora-28292 : No Domain Policy registered for Kerberos based authentication
  • ora-31091 : empty string specified as a SQL name
  • ora-24382 : statement handled already executed or described
  • ora-25144 : invalid option for CREATE TABLESPACE with TEMPORARY contents
  • ora-29814 : expecting USING or DEFAULT keyword
  • ora-29741 : IMR active for some, but not all members of cluster
  • ora-24503 : codepoint length overflows for piecewise operation
  • ora-06512 : at stringline string
  • ora-04078 : OLD and NEW values cannot be identical
  • ora-26091 : requested direct path operation not supported
  • ora-29879 : cannot create multiple domain indexes on a column list using same indextype
  • ora-01261 : Parameter string destination string cannot be translated
  • ora-30512 : cannot modify string.string more than once in a transaction
  • ora-22614 : error while construction the collection in the image
  • ora-30956 : invalid option for XML Index
  • ora-27161 : request for Oracle binary information failed
  • ora-02164 : DATAFILE clause specified more than once
  • ora-38448 : Indexing predicates with "string" operator is not supported.
  • ora-00238 : operation would reuse a filename that is part of the database
  • ora-08106 : cannot create journal table string.string
  • ora-33425 : (EIFMAKEF15) CAUTION: Exporting NTEXT objects using string for the EIF file character set can cause loss of data. To preserve all NTEXT data, export using the UTF8 character set for the EIF file.
  • ora-25221 : enqueue failed, signature specified queue not supporting non-repudiation
  • ora-06301 : IPA: Cannot allocate driver context
  • ora-12634 : Memory allocation failed
  • ora-37104 : (XSVPART04) A partitioned variable must be dimensioned by a single partition template only.
  • 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.