CODEWITHSUNDEEP
sqldatabaseoracle-databaseoracle10g
Abdullah Darwish
Abdullah Darwish

Reputation: 223

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?

Upvotes: 1

Views: 2106

Answers (1)

Rene
Rene

Reputation: 10551

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

Upvotes: 3

Related Questions