469,282 Members | 1,715 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,282 developers. It's quick & easy.

Copy (Import) Data from Oracle Database To Another

I want to Copy a data from One oracle database to another.

I have checked Import/Export Utility but the problem is import utility doesn't support conflicts resolution techniques between rows.

For Example if there's a table in the source database have the same row key in the destination database. if i use 'Ignore' parameter with value = y, the destination table will have a duplicate rows.

I want to ask if there's another way to import data from oracle database to another with some mechanism of detecting the conflicts and resolve them?
Jun 6 '13 #1
1 1951
700 Expert 512MB
If table source is not so big you can define dblink and use merge statement when you load data into destinatinon table.

If source table is big then the best will be to import data from a file into some temp table, and then merge this temp table rows into destination table.

Here you can find info abt dblink http://docs.oracle.com/cd/B19306_01/...ments_5005.htm and merge statement http://docs.oracle.com/cd/B28359_01/...ments_9016.htm.
Jun 8 '13 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by John Kolvereid | last post: by
4 posts views Thread by Glen A Stromquist | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.