ORA-26011: Cannot load type string into column string in table string

Cause : A oclunm cna olny tsor edaat o ftyep dcelaerd ofr htatc olmun.A nda sbusttiutbalec olmun acn nolys toer dtaa fo vlaids ubytpe soft hes upretyep dcelaerd ofr htatc olmun.

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

Chcek htatt het yp eors ubytpes peicfide i svaild ofr htatc olmun.

update : 26-04-2017
ORA-26011

ORA-26011 - Cannot load type string into column string in table string
ORA-26011 - Cannot load type string into column string in table string

  • ora-16062 : DGID from standby not in Data Guard configuration
  • ora-16145 : archival for thread# string sequence# string in progress
  • ora-32801 : invalid value string for string
  • ora-01286 : start interval required
  • ora-12900 : must specify a default temporary tablespace for a locally managed database
  • ora-29349 : tablespace 'string' already exists
  • ora-40001 : value for string must be greater than zero
  • ora-16068 : redo log file activation identifier mismatch
  • ora-29517 : recursive resolution failed for a referenced class
  • ora-38432 : EVALUATE operator only allowed on an expression column
  • ora-09935 : Unlink of current password file failed.
  • ora-19772 : change tracking file name exceeds limit of string characters
  • ora-37077 : (XSMCSESS05) Object workspace object is specified more than once.
  • ora-36400 : (XSSPROP02) workspace object is not a valid variable name.
  • ora-32740 : The requested operation cannot be proceeded
  • ora-04012 : object is not a sequence
  • ora-16756 : resource guard could not open standby database read-only
  • ora-27029 : skgfrtrv: sbtrestore returned error
  • ora-31157 : Invalid Content-Type charset
  • ora-02722 : osnpui: cannot send break message to orapop
  • ora-13261 : geometry table string does not exist
  • ora-00447 : fatal error in background process
  • ora-25290 : Cannot complete operation on queue string with existing messages
  • ora-30938 : No prefix defined for namespace 'string' (particle string)
  • ora-12091 : cannot online redefine table "string"."string" with materialized views
  • ora-19554 : error allocating device, device type: string, device name: string
  • ora-24295 : max key length (string) for sorted hash cluster exceeded
  • ora-12728 : invalid range in regular expression
  • ora-07610 : $GETJPIW failed in retrieving the user's MAC priviledges
  • ora-25137 : Data value out of range
  • 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.