ORA-23346 DURING GENERATE_REPLICATION_SUPPORT
Last updated on MAY 05, 2017
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 to 10.2.0.4 [Release 8.0.3 to 10.2]
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
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