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
lotusdeva
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: Thu Dec 12 05:52:10 CST 2024