Oracle Database Errors or Warnings from Error ORA-23338 to ORA-23347

SQLServerF1

ORA-23338: priority or value already in priority group string
Cause: The specified value or priority has already been registered as part of the priority group.
Action: Either specify a different value or priority that not already part of the priority group, or drop the value to the priority group.
ORA-23339: duplicate conflict resolution information
Cause: The specified combination of column group, sequence, conflict type and/or parameter table name, parameter column name, and parameter sequence number has already been registered.
Action: Verify that additional conflict resolution information needs to be added and provide a new sequence number. If modifying existing information, the existing information must be dropped first.
ORA-23340: incorrect resolution method string
Cause: User function is specified when conflict resolution method was not “USER FUNCTION” or specified resolution method is not one of the predefined methods.
Action: If user function is specified when conflict resolution method was not “USER FUNCTION”, either reregister function with method as “USER FUNCTION” or specify a NULL user function. Otherwise Specify one of the documented supported conflict resolution methods.

ORA-23341: user function required
Cause: A NULL user function was specified for the “USER FUNCTION” method.
Action: Provide user function name (e.g., “schema”.”package”.”function”) that conforms to the documented user function specifications or specify one of the documented supported conflict resolution methods.
ORA-23342: invalid parameter column string
Cause: The parameter column name is null or misspelled, the invocation database is not a master, or is of the wrong type for the specified conflict resolution method.
Action: Specify a parameter column from the specified column group that has a correct type for the conflict resolution method.
ORA-23343: no match for specified conflict resolution information
Cause: The specified combination of column group, sequence, conflict type has not been registered (e.g., for adding a comment).
Action: Specify a combination of column group, sequence, conflict type has been registered.

ORA-23344: constraint (string.string) does not exist
Cause: A null, misspelled or nonexistent constraint was specified when registering a uniqueness conflict.
Action: Register a named constraint for the specified table.
ORA-23345: table “string”.”string” not registered to collect statistics
Cause: A procedure that deals with conflict resolution statistics-gathering was called for a table that was not registered to collect statistics.
Action: Call dbms_repcat.register_statistics to register the table.
ORA-23346: primary key or object ID is undefined for table or materialized view string
Cause: Trying to generate replication support for a table or materialized view without a primary key (as defined by a constraint or dbms_repcat.set_columns) or an object ID.
Action: For a table, add a primary key constraint or define a primary key using dbms_repcat.set_columns or use object tables. For a ROWID materialized view, set min_communication to false or use primary key or object ID materialized views.
ORA-23347: datatype string for column string table string not supported
Cause: The table has a column whose datatype is not supported by repcat.
Action: Remove the column from the table, or alter the column to have one of the supported datatypes.

Above are list of Oracle Database Errors or Warnings from Error ORA-23338 to ORA-23347 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 *