ORA-26689: column datatype mismatch in LCR

Cause : The datatypes of columns in the LCR are not the same as the datatypes in the database object.

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

Alter the database object.

update : 21-08-2017

ORA-26689 - column datatype mismatch in LCR
ORA-26689 - column datatype mismatch in LCR

  • ora-12899 : value too large for column string (actual: string, maximum: string)
  • ora-32316 : REFRESH FAST of "string"."string" unsupported after mixed DML
  • ora-01267 : Failure getting date/time
  • ora-21605 : property [string] is not a property of value instances
  • ora-22280 : no more buffers available for operation
  • ora-07655 : slsprom:$TRNLOG failure
  • ora-36696 : (XSRELTBL02) QDR dimension workspace object should not be the related dimension of the relation.
  • ora-14064 : Index with Unusable partition exists on unique/primary constraint key
  • ora-30110 : syntax error at 'string'
  • ora-30462 : unsupported operator: string
  • ora-38710 : Flashback log version string is incompatible with ORACLE version string.
  • ora-14621 : cannot add subpartition when DEFAULT subpartition exists
  • ora-19725 : can not acquire plug-in enqueue
  • ora-02034 : speed bind not permitted
  • ora-31676 : illegal value for number of workers, string
  • ora-09350 : Windows 32-bit Two-Task driver unable to allocate context area
  • ora-33223 : (CMOVE03) You cannot move a session-only dimension value.
  • ora-16247 : DDL skipped on internal schema
  • ora-10841 : Default un-inintialized charact set form to SQLCS_IMPLICIT
  • ora-01231 : cannot make read write - file string is offline
  • ora-33084 : (XSAGDNGL42) In AGGMAP workspace object, you cannot qualify the dimensioned valueset workspace object.
  • ora-07237 : slemcl: invalid file handle, seals do not match.
  • ora-02035 : illegal bundled operation combination
  • ora-33462 : (ESDREAD10A) Discarding compiled code for workspace object because object number is not in analytic workspace string.
  • ora-15053 : diskgroup "string" contains existing files
  • ora-07495 : spwat: lm_wait failed.
  • ora-13511 : invalid INTERVAL string, must be in the range (string, string)
  • ora-28048 : database is a member of multiple enterprise domains in OID
  • ora-27027 : sbtremove2 returned error
  • ora-19690 : backup piece release string incompatible with Oracle release string
  • 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.