ORA-23346: primary key or object ID is undefined for table
or materialized view string



ORA-23346: primary key or object ID is undefined for table or materialized view string..

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-12091: cannot online redefine table "string"."string" with materialized views

1 Answers  


ORA-39117: Type needed to create table is not included in this operation. Failing sql is: string

1 Answers  


PLS-00658: constructor method name must match type name

1 Answers  


LSX-00210: value "~1S" out of range for type "~2S"

1 Answers  


ORA-12838: cannot read/modify an object after modifying it in parallel

1 Answers  


ORA-09265: spwat: error temporarily suspending process

1 Answers  


ORA-23483: object "string"."string" not allowed in this operation.

1 Answers  


ORA-19674: file string is already being backed up with proxy copy

1 Answers  


ORA-15021: parameter "string" is not valid in string instance

1 Answers  


ORA-01470: In-list iteration does not support mixed operators

1 Answers  


ORA-19571: %s recid string stamp string not found in controlfile

1 Answers  


ORA-16738: log tranport service for standby "string" unexpectedly offline

1 Answers  


Categories