SQL & PL/SQL

Database Version: 11g

Hi Guys,

I have got a situation where I need to merge different databases (Oracle) into one.

Every database has same table structure.

I decided to take the dump from each database and create anew schema, create tables and import the

Data using logical backup that is .dmp

The situations i have figure out are as follows

1. Primary Key issue:

Let’s take a table 'A' in one database in another database also i have table 'A' but the sequences

Will be out of sync for that i have decided to use REMAP_DATA for generating different sequence numbers but need

Take care of child tables as well not sure how i can do that

1 abc

1 dfg

Merged data

1 abc

2 dfg

2. Duplicates:

Duplicates will not be inserted from .dmp files which is ok for me as i do not want duplicate data.

1 abc

1 abc

Merged data

1 abc


3. Sequence Difference:

1 abc

2 abc

Merged data:

1 abc

Any ideas for merging these cases will be appreciated

Thanks in advance