Oracle Database Errors or Warnings from Error ORA-23367 to ORA-23376


ORA-23367: table string is missing the primary key
Cause: Table specified in argument “oname1” or “oname2” in call to “differences()” routine does not contain either a primary key or a virtual primary key (defined through dbms_repcat package under symmetric replication).
Action: Make sure the tables specified have a primary key defined.
ORA-23368: name string cannot be null or the empty string
Cause: Argument “sname1,” “sname2,” “oname1,” “oname2,” “missing_rows_sname,” “missing_rows_oname1,” “missing_rows_oname2” to “differences()” or “rectify()” cannot be NULL or ” (empty string).
Action: Change argument to non-null or non-empty string.
ORA-23369: value of “string” argument cannot be null
Cause: Argument “max_missing” to “differences()” routine cannot be NULL.
Action: Legal values for “max_missing” are integers 1 or greater.

ORA-23370: table string and table string are not shape equivalent (string)
Cause: The tables specified are not shape equivalent, which means intuitively that the number of columns, the names, their datatypes and lengths are not the same. Specifically, problem is in the parentheses and is one of the following: the number of columns are not equal, datatypes of columns with same name in different tables are different, lengths of varchar2 and char columns are not equal, precision and scale of number datatypes are not equal.
Action: Make sure the two tables being compared have the same number of columns, same column names, and same datatypes.
ORA-23371: column string unknown in table string
Cause: Some column in “array_columns” argument (or “column_list” argument) to “differences()” routine does not correspond to a column in the specified table.
Action: Make sure that all the columns in either “array_columns” or “column_list” are present in the specified table.
ORA-23372: type string in table string is unsupported
Cause: Certain types in the table comparison utility are not supported.
Action: Make sure that the types of columns in the tables to be compared are the ones supported by symmetric replication.

ORA-23373: object group “string”.”string” does not exist
Cause: The group name was null or misspelled, or the group does not exist locally.
Action: Specify the group correctly, or create it with dbms_repcat.create_master_repgroup().
ORA-23374: object group “string”.”string” already exists
Cause: The given database already replicates the given object group. A materialized view repgroup cannot be created at a given site where a master repgroup with the same name already exists.
Action: Choose a different group or a different database.
ORA-23375: feature is incompatible with database version at string
Cause: A feature not compatible with the specified database was used
Action: Set or raise the value of the “compatible” INIT.ORA parameter to match the necessary compatibility level.
ORA-23376: node string is not compatible with replication version “string”
Cause: A feature not compatible with the remote database was used
Action: Upgrade the remote database and retry the operation

Above are list of Oracle Database Errors or Warnings from Error ORA-23367 to ORA-23376 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.

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 *