Oracle DB Error ORA-23346 primary key or object ID is undefined for table or materialized view string

Oracle DB Error ORA-23346 primary key or object ID is undefined for table or materialized view string

The following is the cause of this error:

An attempt was made 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 you can take to resolve this issue: 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.


Tags: Database, Microsoft, Oracle, SQL, Software, DBMS, Error Messages, Directory




Disclaimer:Pak/ed and the contributors are not responsible for any errors contained and are not liable for any damages resulting from the use of this material.  Disclaimer


Related

Home      Disclaimer      Advertise      Contact      Privacy Policy     

Copyright © 2004-16 Paked.com. All rights reserved.

Note: Site best viewed at 1024 x 768 or higher screen resolution