ORA-23346 DURING GENERATE_REPLICATION_SUPPORT (Doc ID 1059092.6)

Last updated on MAY 05, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 8.0.3.0 to 10.2.0.4 [Release 8.0.3 to 10.2]
Information in this document applies to any platform.

Symptoms

ORA-23346, ORA-23308, OR ORA-23416 DURING REPLICATION SETUP

Changes

You receive any of the following errors whilst setting up replication:


23346, "primary key is undefined for table or snapshot %s"
// *Cause: Trying to generate replication support for a table or snapshot
// without a primary key as defined by a constraint or
// dbms_repcat.set_columns.
// *Action: For a table, add a primary key constraint or define a primary
// key using dbms_repcat.set_columns. For a rowid snapshot, set
// min_communication to false or use a primary key snapshot.
//

23308, "object %s.%s does not exist or is invalid"
// *Cause: The given name was null or misspelled, the given type was wrong,
// the object does not exist as a valid database object, or the object
// does not exist as a replicated object with the appropriate status.
// *Action: Ensure the object is valid in the database, is visible to the
// user, and, if appropriate, is a valid object in all_repobject.

23416 "table %s . %s does not contain a primary key constraint"
// *Cause: The master table does not constaint a primary key constraint or the
// primary key constraint has been disabled.
// *Action: Create a primary key constraint on the master table or enable the
existing constraint.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms