Q

Replicating a table without primary key

How do I replicate a table that doesn't have a primary key? The database to be replicated can't be modified. So creating a primary key constraint for that table is out of question. I have already created the snapshot log for that table (using ROWID instead of primary key option). But while adding the table to snapshot group, I get an error in the last step:
ORA-12014: Table "ARCOLMTT" does not contain primary key constraint.
You will need a primary key on your table. Is there any reason why you can't add a primary key? Even if your table's columns do not form a natural primary key, you can always add an identity column which is populated, via a trigger, with a sequence number. You can add a primary key and perform your replication.

Dig Deeper on Oracle database backup and recovery

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close