Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

trigger to update remote mysql databse

149162Nov 11 2004 — edited Nov 18 2004
here is the scenario:
we have 4 oracle databases and have been asked to create a central mysql database which would have parts of the data from all 4 databases. Now the transfer of data from oracle to mysql should be scheduled or triggered by any changes to the tables/ fields in use.

is it possible to create triggers in oracle
with which data from oracle tables can be sent to
a remote mysql database and its table/s populated?

if populating a mysql table remotely using an oracle trigger is not possible then perhaps the trigger can create data files and then throw the files to the mysql server.

if this is not possible then what alternatives do we have?

thanks


Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 16 2004
Added on Nov 11 2004
20 comments
943 views