1

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?

Improve this question
5
  • What resolution are you thinking of? Not inserting the new data, overwriting the old data? Commented Jun 6, 2013 at 12:10
  • @David Aldridge the resolution may be overwriting or merging the 2 rows Commented Jun 6, 2013 at 12:24
  • @Dan Bracuk could u describe more Commented Jun 6, 2013 at 12:24
  • What's the difference between overwriting and merging? Commented Jun 6, 2013 at 13:05
  • Merging like taking data from field form source row and take values of another field from the destination form the result row Commented Jun 6, 2013 at 14:09

1 Answer 1

Reset to default
3

You might want to consider using a database link from database A to database B. You can query the data from database B to insert into your database A tables. You are free to query whatever you want using SQL or PL/SQL.

More on database links:

http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_5005.htm

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.