My Oracle Support Banner


Last updated on SEPTEMBER 02, 2021

Applies to:

Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Database - Enterprise Edition - Version to [Release 8.0.3 to 10.2]
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.




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.


To view full details, 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 a vibrant support community of peers and Oracle experts.