how to take binary/ascii dump of table?
[EMAIL PROTECTED] wrote: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 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!
---------------------------------
Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages!
