ORA-23346 DURING GENERATE_REPLICATION_SUPPORT
(Doc ID 1059092.6)
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 18.104.22.168 to 10.2.0.4 [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.
ORA-23346, ORA-23308, OR ORA-23416 DURING REPLICATION SETUP
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
// *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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!