DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Connect MYSQL from ORACLE

  1. #1
    Join Date
    Jan 2000
    Posts
    387

    Connect MYSQL from ORACLE

    Hi

    I would like to use mysql as a backup database. May I know how to insert/update changes made from Oracle database to Mysql? Can it be done by Oracle trigger?

    Thanks!

  2. #2
    Join Date
    Jan 2000
    Posts
    387
    Are there any alternatives? Or it can be done with an open connection from Oracle to mysql?

  3. #3
    Join Date
    Oct 2002
    Location
    Breda, The Netherlands
    Posts
    317
    Lookup the chapter "Heterogenous services" in your local Oracle-documentation-corner. That'll probably do the trick.

    Erik
    An expert is one who knows more and more about less and less until he knows absolutely everything about nothing.

  4. #4
    Join Date
    Jan 2000
    Posts
    387
    Thanks! I read up on the distributed database from oracle documentation. It mentioned mostly on database links which only applies for oracle databases.

    How do i setup for Mysql database? Any notes or help please?

    Much appreciated!

  5. #5
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    688
    As for me, I would write external function.
    Best wishes!
    Dmitri

  6. #6
    Join Date
    Jan 2000
    Posts
    387
    What do you mean by external function? How will it be able to detect if there are any changes made in Oracle database before updating them to mysql?

  7. #7
    Join Date
    Jan 2000
    Posts
    387
    Does Oracle Heterogeneous Services supports mysql?

  8. #8
    Join Date
    Jan 2000
    Posts
    387
    Any more advices please? Many thanks!

  9. #9
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    688
    Originally posted by mooks
    What do you mean by external function? How will it be able to detect if there are any changes made in Oracle database before updating them to mysql?
    Create trigger on Oracle table and call this function/procedure from the trigger.
    Triger should fire on INS/UPD/DEL.
    Best wishes!
    Dmitri

  10. #10
    Join Date
    Jan 2000
    Posts
    387
    When calling the external Oracle procedure, it cannot update in mysql database in another server right?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width