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

Thread: Connect MYSQL from ORACLE

  1. 10-02-2003, 02:11 AM #1
    mooks
    mooks is offline Senior Member
    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!
    Reply With Quote Reply With Quote
  2. 10-02-2003, 03:57 AM #2
    mooks
    mooks is offline Senior Member
    Join Date
    Jan 2000
    Posts
    387
    Are there any alternatives? Or it can be done with an open connection from Oracle to mysql?
    Reply With Quote Reply With Quote
  3. 10-02-2003, 04:24 AM #3
    efrijters's Avatar
    efrijters
    efrijters is offline humble grasshopper
    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.
    Reply With Quote Reply With Quote
  4. 10-02-2003, 05:19 AM #4
    mooks
    mooks is offline Senior Member
    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!
    Reply With Quote Reply With Quote
  6. 10-02-2003, 12:08 PM #5
    kgb
    kgb is offline Advisor
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    688
    As for me, I would write external function.
    Best wishes!
    Dmitri
    Reply With Quote Reply With Quote
  7. 10-02-2003, 09:43 PM #6
    mooks
    mooks is offline Senior Member
    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?
    Reply With Quote Reply With Quote
  8. 10-03-2003, 04:46 AM #7
    mooks
    mooks is offline Senior Member
    Join Date
    Jan 2000
    Posts
    387
    Does Oracle Heterogeneous Services supports mysql?
    Reply With Quote Reply With Quote
  9. 10-07-2003, 05:23 AM #8
    mooks
    mooks is offline Senior Member
    Join Date
    Jan 2000
    Posts
    387
    Any more advices please? Many thanks!
    Reply With Quote Reply With Quote
  11. 10-07-2003, 07:56 AM #9
    kgb
    kgb is offline Advisor
    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
    Reply With Quote Reply With Quote
  12. 10-08-2003, 06:04 AM #10
    mooks
    mooks is offline Senior Member
    Join Date
    Jan 2000
    Posts
    387
    When calling the external Oracle procedure, it cannot update in mysql database in another server right?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width