database sync [message #72789] |
Mon, 20 October 2003 13:04 |
kshathrya
Messages: 29 Registered: October 2001
|
Junior Member |
|
|
if i have db1 ad db2. both has to be in sync now and then.
lets say i have sequences and stuff in both db's. i always work on db1. before every production move i have to sync to db2. what is the best practise & an easy one?
|
|
|
Re: database sync [message #72793 is a reply to message #72789] |
Tue, 21 October 2003 01:41 |
|
Mahesh Rajendran
Messages: 10708 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
for asynchronous replication and periodic in request data refresh, you can just export and import.
for more comlex replication, with multiple sites, you may need to look into multimaster replication.
|
|
|