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!

Report message to a moderator

Previous Topic: Merge over dblink - too slow..
Next Topic: Parallel queries.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 23 11:09:08 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.