DB Import with same schema but duplicate keys [message #452039] |
Mon, 19 April 2010 12:40 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
atheis
Messages: 7 Registered: April 2010
|
Junior Member |
|
|
I have two oracle 9i databases A and B with complete equal schema.
Only the data is different. I want to import all table data from A to B. The problem is that there are duplicate primary keys. Therefore I want to insert data with new primary keys (all referencing tables are concerned too). Are there any existing tools/solutions?
[Updated on: Mon, 19 April 2010 12:41] Report message to a moderator
|
|
|
|
|
|
|
|
|
|
Re: DB Import with same schema but duplicate keys [message #452163 is a reply to message #452039] |
Tue, 20 April 2010 07:34 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
cookiemonster
Messages: 13937 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
And sometimes in real life you discover that there is a really good reason for the theory - this'd be one of them.
Bottom line, you're going to have to write a lot of SQL to sort the mess out, either after importing into another schema as Michel suggested, or by skipping the import and using DB links as Littlefoot suggested.
|
|
|
|
|
|
|
|