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 : 25-06-2017
ORA-26689

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

  • ora-36768 : (XSAGGCNTMOVE06) An aggregation variable and its AGGCOUNT must have the same base dimensions.
  • ora-08192 : Flashback Table operation is not allowed on fixed tables
  • ora-28538 : result set not found
  • ora-29285 : file write error
  • ora-19204 : Non-scalar value 'string' is marked as XML attribute
  • ora-08277 : Cannot set environment variable
  • ora-01524 : cannot create data file as 'string' - file already part of database
  • ora-34143 : (MXCGPUT02) You cannot assign values to SURROGATE workspace object because it is type INTEGER.
  • ora-22277 : cannot use two different locators to modify the same LOB
  • ora-27053 : blocksize in file header not a multiple of logical block size
  • ora-25005 : cannot CREATE INSTEAD OF trigger on a read-only view
  • ora-01002 : fetch out of sequence
  • ora-36261 : (XSAGPARTDEP00) Can not Aggregate PARTITION TEMPLATE %J because the path of aggregation would recursively enter partition %J.
  • ora-01144 : File size (string blocks) exceeds maximum of string blocks
  • ora-30952 : illegal configuration of HTTP/HTTPS in xdbconfig.xml
  • ora-32774 : more than one file was specified for bigfile tablespace string
  • ora-16001 : database already open for read-only access by another instance
  • ora-25231 : cannot dequeue because CONSUMER_NAME not specified
  • ora-31456 : error executing a procedure in the DBMS_CDC_UTILITY package
  • ora-19043 : Multiply nested XMLROOT function disallowed
  • ora-13251 : duplicate entry string in metadata table
  • ora-30462 : unsupported operator: string
  • ora-26667 : invalid STREAMS parameter string
  • ora-13370 : failure in applying 3D LRS functions
  • ora-37036 : (XSMLTDCL02) You cannot DELETE objects in analytic workspace string because it is attached in MULTI mode.
  • ora-29928 : duplicate default selectivity specified
  • ora-31009 : Access denied for property string
  • ora-36804 : (XSTBLFUNC02) The OLAP_TABLE function encountered an error while parsing the LIMITMAP.
  • ora-01261 : Parameter string destination string cannot be translated
  • ora-16744 : the DG_CONFIG list of LOG_ARCHIVE_CONFIG parameter is full
  • 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.