AFAIK, MySQL servers can only talk to other MySQL servers and that is only through the replication protocol/connections. Beyond that you will need to make your server-to-server connections through some kind of external client. Can Oracle act as a client to foreign databases? If it cannot, I believe you will need to write some code to develop a custom solution. It may be possible to use the MySQL source code to enable your custom client to behave as a MySQL replication slave then transform the binlog entries you receive into valid Oracle statements. Other than that, I think that you would need to periodically poll the MySQL server for changes and duplicate them into your Oracle server.
Shawn Green Database Administrator Unimin Corporation - Spruce Pine Seena Blace <[EMAIL PROTECTED]> wrote on 09/01/2004 12:30:12 PM: > Hi, > > I wanted to setup connectivity between mysql database and oracle > database.I have one database in mysql from which all tables data I > want to insert real time data into oracle database.How to connect > mysql database with oracle database? > thanks > > > --------------------------------- > Do you Yahoo!? > New and Improved Yahoo! Mail - Send 10MB messages!
