Oracle Database Errors or Warnings from Error ORA-26683 to ORA-26692

SQLServerF1

ORA-26683: invalid value for value_type
Cause: The value_type parameter should be either ‘OLD’ or ‘NEW’
Action: Retry with proper value_type.
ORA-26684: invalid value for value_type
Cause: The value_type parameter should be one of ‘OLD’, ‘NEW’ or ‘*’
Action: Retry with proper value_type.
ORA-26685: cannot apply transactions from multiple sources
Cause: Transactions from multiple sources were sent to the same apply process.
Action: Create multiple apply processes and create appropriate rules so that transactions from only one source reach an apply process.

ORA-26686: cannot capture from specified SCN
Cause: An attempt was made to specify an invalid SCN.
Action: Retry with a valid SCN.
ORA-26687: no instantiation SCN provided for “string”.”string” in source database “string”
Cause: Object SCN was not set. If the object is a table, then both fields will be filled, for example “SCOTT”.”EMP”. If the object is a schema, only one field will be set, for example “SCOTT”.””. And if the object is the entire database, no fields will be set, for example “”.””.
Action: Set the SCN by calling DBMS_APPLY_ADM.SET_%_INSTANTIATION_SCN
ORA-26688: missing key in LCR
Cause: Metadata mismatch, or not enough information in the user generated LCR.
Action: Alter the database object, or provide all defined keys in the LCR.

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: Alter the database object.
ORA-26690: datatype not supported at non-Oracle system
Cause: One of the columns of the LCR being applied was of a datatype not supported by either the target non-Oracle system or by the Oracle transparent gateway through which the apply is being done.
Action: Do not apply data of this type. If possible, filter out columns containing such datatypes before applying.
ORA-26691: operation not supported at non-Oracle system
Cause: The apply process attempted an operation that is either not supported by the non-Oracle system or by the Oracle transparent gateway through which the apply is being done. Some kinds of DML (like procedure and function calls) and all DDL will cause this error to be raised.
Action: Do not attempt to apply such LCRs to non-Oracle systems. If possible, filter out such LCRs before applying.
ORA-26692: invalid value string, string should be in string format
Cause: The parameter specified was not in the correct format.
Action: Specify the parameter value in the correct format.

Above are list of Oracle Database Errors or Warnings from Error ORA-26683 to ORA-26692 received while performing certain operation against Oracle Database or related products.

What are Oracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database. Each Oracle Database Error or Warning Message mentioned above contains the Warning or Error Message Statement, a short explanation of the probable causes of the Error message, and a recommended action.

Hope this was helpful.

Thanks,
SQLServerF1 Team
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.

 

Leave a Reply

Your email address will not be published. Required fields are marked *