Home » Server Options » Replication » Reg Special Case of Database Replication
Reg Special Case of Database Replication [message #75055] Mon, 28 May 2001 23:50 Go to next message
mrekha
Messages: 1
Registered: May 2001
Junior Member
There is a local db and a remote db.The requirement is that the table structure in the databases are not the same and data has to be synchronised between the local and central db.
is it possible to write a BATCH PROCESS(whose time period can be configured)which gets data from the local db (based on a status field)into a xml file and then transports the file provided internet connection exists and on the remote database side,the xml file is read and data fed into the remote db.also when the transfer happens successfully, the local db has to be informed so that the status field of the records in the local db gets changed.(that's really long right!)
pls provide info on batch process.also where does oracle xml parser for java fit in?
Any HELP asap wud be appreciated.Thanx in advance.

----------------------------------------------------------------------
Re: Reg Special Case of Database Replication [message #75057 is a reply to message #75055] Mon, 04 June 2001 12:31 Go to previous message
Gabriel
Messages: 11
Registered: February 2001
Junior Member
You would probably need the XMLParser package to create the XML document and to extract data from the XML document, and to do that, you would probably have to write java code and store them in your db's as java store procedures and call them with pl/sql or sql calls.

As for the batch process I'm not to sure about that.

----------------------------------------------------------------------
Previous Topic: syncronizing two database
Next Topic: Replication of the data from isolated database
Goto Forum:
  


Current Time: Fri Oct 23 00:06:23 CDT 2020