Home » Developer & Programmer » JDeveloper, Java & XML » Need help on Oracle
Need help on Oracle [message #366719] Wed, 01 November 2000 04:59
Mahesh Mangat
Messages: 1
Registered: November 2000
Junior Member
I have a java program which transfers the data from Oracle to MS Sql Server. This program runs every day night. There is a one day lag for updated information in MS SQL Server. I wanted to do this activity online, so that the information will be updated in both the databases simultaneously. To achieve this, when ever there is a table change in oracle I wanted to call this program which will update the MS Sql server database. I don't want to write the trigger on each table to call my java program. Is there any alternatives other that the trigger to achieve this task. Any comments or suggestions are appreciated.
Oracle database is Oracle(7.3) and Sql Server Database is (7.0)
Previous Topic: Java2 access Oracle8.1.5.0
Next Topic: Problem connect oracle 7.3 at frist time.
Goto Forum:
  


Current Time: Fri Mar 29 00:40:41 CDT 2024