ORA-02269: key column cannot be of LONG datatype

Cause : Self-veident.

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

Chang ethe dtaatypeo f thec olumn ,or reomve th ecolum nfrom hte key.

update : 20-09-2017

ORA-02269 - key column cannot be of LONG datatype
ORA-02269 - key column cannot be of LONG datatype

  • ora-16954 : SQL parse error.
  • ora-07860 : osnsoi: error setting up interrupt handler
  • ora-16706 : no resource guard is available
  • ora-32630 : multiple assignment in automatic order MODEL
  • ora-33298 : (AWUPG01) Analytic Workspace string is already in the newest format allowed by the current compatibility setting
  • ora-19273 : XQ0053 - empty string in namespace declaration
  • ora-39003 : unable to get count of total workers alive
  • ora-29269 : HTTP server error string
  • ora-13908 : Invalid combination of metrics id and object type parameters.
  • ora-02491 : missing required keyword ON or OFF in AUTOEXTEND clause
  • ora-09360 : Windows 3.1 Two-Task driver unable to allocate context area
  • ora-13413 : null or invalid resampling parameter
  • ora-12039 : unable to use local rollback segment "string"
  • ora-37038 : (XSMLTDCL04) You cannot change definitions of objects in analytic workspace string because it is attached in MULTI mode.
  • ora-24183 : invalid transformation
  • ora-00025 : failed to allocate string
  • ora-13233 : failed to create sequence number [string] for R-tree
  • ora-26686 : cannot capture from specified SCN
  • ora-27369 : job of type EXECUTABLE failed with exit code: string
  • ora-29545 : badly formed class: string
  • ora-13706 : Invalid value "string" specified for parameter "string" in "string" analysis mode.
  • ora-27035 : logical block size is invalid
  • ora-22854 : invalid option for LOB storage index
  • ora-00338 : log string of thread string is more recent than control file
  • ora-00295 : datafile/tempfile number string is invalid, must be between 1 and string
  • ora-19228 : XP0008 - undeclared identifier: prefix 'string' local-name 'string'
  • ora-02032 : clustered tables cannot be used before the cluster index is built
  • ora-27213 : failed to unload Media Management Library
  • ora-38735 : Wrong log number string in flashback log file header.
  • ora-07223 : slspool: fork error, unable to spawn spool process.
  • 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.