replicate data of 3 databases into 1

Hello Oracle Masters

I have a question about oracle replication.

i have 3 diff. units running a erp package. each unit has its own server and database. transactions in each units are defined seperately. means in each transaction or master file there is unitcode reference like :
UC1 For Unit ONE
UC2 For Unit TWO
UC3 For Unit Three

More over each primary key generated with a reference of 1,2,3 for individual unit like : Purchase Order Number For each unit will be:

PO-1.220104.001 For Unit ONE
PO-2.220104.001 For Unit TWO
PO-3.220104.001 For Unit Three

Now i want to replicated data of all 3 units into one single database. please suggest what will be the best solution.

Regards

Gurpreet Singh Sethi

Quote:

---

Originally posted by sethi

Now i want to replicated data of all 3 units into one single database.

---

Elaborate!

If all 3 instances run independant of each other, I think taking export of each and importing it into the MASTER db under 3 diff schemas would be fine.

depends on what you want to accomplish ... Snapshot replication where 1 database has ALL data. It replicates to snapshot databases based on the primary key (or user defined query).

Gregg

Before u go into replication better u need to study in detail about the replication.AS when u will try to murge the data from different servers into one u may end up with conflicts.What is conflicts? check in the manuals.