Re: dblink mysql to oracle
Read on Oracle's Heterogeneous Services, allows to connect (through db-link) to foreign databases using ODBC. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, June 02, 2002 8:08 PM i want to be able to select mysql data from oracle simular (in some way) to how i do via dblinks 'select * from table@otherdb' is there a way to do something like this? --- Gabriel C. Millerd | Eternal nothingness is fine if you happen to be Super Plumber | dressed for it. -- Woody Allen | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gabriel C Millerd INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: dblink mysql to oracle
I dunno about MySQL, but from oracle you can have external procedures accessing MySQL and returning data into oracle. There is also a TNS API which allows you to write your very own transparent gateway and select data from MySQL. -Original Message- From: Gabriel C Millerd [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 02, 2002 8:08 PM To: Multiple recipients of list ORACLE-L Subject: dblink mysql to oracle i want to be able to select mysql data from oracle simular (in some way) to how i do via dblinks 'select * from table@otherdb' is there a way to do something like this? --- Gabriel C. Millerd | Eternal nothingness is fine if you happen to be Super Plumber | dressed for it. -- Woody Allen | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gabriel C Millerd INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: dblink mysql to oracle
On Mon, 3 Jun 2002, Gogala, Mladen wrote: I dunno about MySQL, but from oracle you can have external procedures accessing MySQL and returning data into oracle. There is also a TNS API which allows you to write your very own transparent gateway and select data from MySQL. is this the 'enabling net8 enhancements for programmers' stuff such as the tftp and finger examples? such as mentioned here: http://technet.oracle.com/doc/oracle8i_816/network.816/a76933/net8open.htm or am i missing something? --- Gabriel C. Millerd | Go not to the elves for counsel, for they will say Sith Admin | both yes and no. -- J.R.R. Tolkien | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gabriel C Millerd INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: dblink mysql to oracle
On Mon, 3 Jun 2002, Igor Neyman wrote: Read on Oracle's Heterogeneous Services, allows to connect (through db-link) to foreign databases using ODBC. this seems more like the way to go .. i didnt expect to have to program anything rather configure oracle, a mysql driver, and transport mechanism. --- Gabriel C. Millerd | The ability to destory a planet is insignificant Script Monkey | next to the power of the force... I find your lack | of faith disturbing. -Lord Vader -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gabriel C Millerd INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
dblink mysql to oracle
i want to be able to select mysql data from oracle simular (in some way) to how i do via dblinks 'select * from table@otherdb' is there a way to do something like this? --- Gabriel C. Millerd | Eternal nothingness is fine if you happen to be Super Plumber | dressed for it. -- Woody Allen | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gabriel C Millerd INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).