Replication....?

[Kashif]

Asslam-o-Alaikum.

Dear Members.
I Have 2 Databases on my Network. and there is a Database link already created.
On both database Have Same Schema and Table Structures.
I want to Copy the Data from One Database to 2nd Database.
now the Current Procedure is
First of All I Delete All the Data From One Database, Disable all the DB Triggers.
and then Copy all the Data from the Other Database.
But NOW it is a Time Consuming Procedure.

I want any easiest and fastest way.
that When data will copy
Any Changed rows should be Updated.
and New Rows Should be Inserted to the 2nd Database.

If any Thing which is not Understandable then please let me know i will explain it briefly



Best Regards.

Muhammad Kashif

[admin]

1- What is the objective of this data copy? Backup or....
2- Database version?
3- Are both databases updatable? Hope not....

[Kashif]

[quote]1- What is the objective of this data copy? Backup or....
2- Database version?
3- Are both databases updatable? Hope not....

<i><div align="right">Originally posted by admin

[imranhad]

AOA
Dear kashif, u can user multimaster and Mview replication mathord
just down load replication user guide from oracle web.

1- In multimaster replication both server are master sites
and they replicated each other.
2- In Mveiw site both site data union is saved in 3rd server.

imran hyder

[Kashif]

[quote]AOA
Dear kashif, u can user multimaster and Mview replication mathord
just down load replication user guide from oracle web.

1- In multimaster replication both server are master sites
and they replicated each other.
2- In Mveiw site both site data union is saved in 3rd server.

imran hyder

<i><div align="right">Originally posted by imranhad

[admin]

http://www.orafaq.com/faqrepl.htm

[imranhad]

http://search.oracle.com/search/search? ... eplication