Home » RDBMS Server » Performance Tuning » MERGE but no PK on the table
MERGE but no PK on the table [message #212864] Mon, 08 January 2007 11:10
Messages: 201
Registered: March 2005
Senior Member
I am not sure how to go about this. I have to synchronize data from a remote db with our db. I am using MERGE feature in Oracle 9i. However, the table that I need to merge with has no PK on it - so there is nothing unique that identifies a particular record. Can I merge without ON statement? How will Oracle know when to update and when to insert? thank you!
Previous Topic: Merge over dblink - too slow..
Next Topic: Parallel queries.
Goto Forum:

Current Time: Fri Jul 21 14:09:03 CDT 2017

Total time taken to generate the page: 0.25441 seconds