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
Replication....?
[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
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
Who is online
Users browsing this forum: No registered users and 0 guests