| Reg Special Case of Database Replication [message #75055] |
Mon, 28 May 2001 23:50  |
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  |
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.
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
