I have 2 Oracle 8 databases that need to be synched on a regular basis.
I do it using imp/exp utilities but now I need to create a script/batch file that the users of these databases could run without my help. The DBs reside on different machines (server and laptop).
I wrote a script to upload server database to the laptop but it doesn't work for some reason. Here is what have so far:
Server to Laptop script:
(where LAPTOPDB = database name on laptop, SERVERDB = database name on server, D:\ = network drive to Server DB machine, C:\ = laptop drive where Laptop database resides)
You can also try using Archived logs. This can be one method to incrementally sync your server and laptop by applying the archived logs. This method may be faster especially if the size of your DB files are large