Re: Merging two tables with primary keys
> Not sure what that means.
It means you now need to form and test rules for deciding which column values in two rows with identical PKs should be kept and which should be archived or discarded.
For example, in a DB that completely implements point-in-time architecture (http://www.artfulsoftware.com/infotree/Transaction%20time%20validity%20in%20MySQL.pdf), you would probably just pick the most recent value of each column.
To the extent your DB does not maintain such history, you will have to devise rules for choosing which column value to keep, and which to archive or discard.
Subject
Written By
Posted
Re: Merging two tables with primary keys
March 25, 2018 10:55AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.