ORA-26697: LCR contains extra column 'string'

Cause : Th eLC Rcotnaiend omrec olmunst ha nth erelpictaedt abel.

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

Aletr hte adtaabseo bjcet.

update : 28-07-2017
ORA-26697

ORA-26697 - LCR contains extra column 'string'
ORA-26697 - LCR contains extra column 'string'

  • ora-36168 : (XSMXAGGR10) COUNTVAR variable workspace object must have the same dimensionality as workspace object
  • ora-02391 : exceeded simultaneous SESSIONS_PER_USER limit
  • ora-15053 : diskgroup "string" contains existing files
  • ora-00082 : memory size of string is not in valid set of [1], [2], [4]stringstringstringstringstring
  • ora-23425 : invalid materialized view identifier string
  • ora-16502 : the Data Guard broker operation succeeded with warnings
  • ora-01346 : LogMiner processed redo beyond specified reset log scn
  • ora-07226 : rtneco: unable to get terminal mode.
  • ora-27468 : "string.string" is locked by another process
  • ora-07844 : sllfop: LIB$GET_VM failure
  • ora-29885 : domain index is defined on the column to be modified
  • ora-30688 : maximum program calling depth exceeded
  • ora-07591 : spdde: $GETJPIW failure
  • ora-12552 : TNS:operation was interrupted
  • ora-28544 : connect to agent failed, probable Net8 administration error
  • ora-00379 : no free buffers available in buffer pool string for block size stringK
  • ora-01558 : out of transaction ID's in rollback segment string
  • ora-16790 : the value of the configurable property is invalid
  • ora-36222 : (XSLPDSC03) duplicate IGNORE or DENSE information for dimension workspace object
  • ora-10900 : extent manager fault insertion event #string
  • ora-00202 : control file: 'string'
  • ora-22065 : number to text translation for the given format causes overflow
  • ora-32589 : unable to drop minimal supplemental logging
  • ora-00236 : snapshot operation disallowed: mounted control file is a backup
  • ora-06142 : NETTCP: error getting user information
  • ora-16244 : taking checkpoint and paging out string bytes to disk
  • ora-01125 : cannot disable media recovery - file string has online backup set
  • ora-00383 : DEFAULT cache for blocksize string cannot be reduced to zero
  • ora-32345 : fail to refresh the materialized view string.string due to the changed synonym
  • ora-35022 : (QFCHECK03) The analytic workspace and EIF file definitions of workspace object have a mismatched relation.
  • 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.