Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Ôõô´Óoracleͨ¹ýodbc ºÍsqlµÃµ½mysql

 oracleµÄodbcÍø¹Ø£¨gateway£©¼¸ºõÌṩһ¸öÎÞÏßµÄÊý¾ÝÕûºÏƽ̨£¬ÔÚoracleºÍÆäËüRDBMSÖ®¼ä£¬ÎÒÔÚÕâ²»Ïë˵ËüµÄ£¬²Ù×÷£¬ÏÞÖÆÒÔ¼°Ïà¹ØÐÔ£¬Ëü½â¾öÁËÒ»¸öСÎÊÌ⣬°ÑËü½¨Á¢ÆðÀ´ÄãÄÜ£¬ÀýÈ磬´´½¨Ò»¸ö database link ÔÚoracle ºÍoracleÖ®¼ä£¬±Ï¾¹£¬ÕâÑù²»ÊǺܺÃô£¬ÀýÈçÄãÄÜÔËÐÐÏÂÃæµÄsqlÓï¾ä£¬
select o.col1, m.col1 from oracle_tab
o, mysql_tab@mysql
m where o.col1=m.col1;

insert into oracle_tab
(select * from mysql_tab@mysql
);

Õâ¸ö¹«Ê¾£¬¾ÍÊÇÒªÓë´ó¼Ò·ÖÏí£¬ÏàͬµÄ·½·¨KARUN È¥Äê ÒѾ­Îªsql server×ö¹ýÁË,Ò»´Ë¹ØÓÚÓÃmysql Á¬½ÓÆ÷odbc£¬ÔÚlinuxÉϽ¨Á¢oracle odbc Íø¹ØµÄÌáʾ¡£
ÐèÇó£º
 ÎÒÒÑÔÚÎҵı¾±¾Éϰ²×°ºÃµÄËùÓеÄÅäÖÃÈ¥²âÊÔÕâ¸ö¹¦ÄÜ£¬²Ù×÷ϵͳÊÇUbuntu Intrepid Ibex 32bits¡£ÎÒ²»ÏëÏÝÈë°Ñthe MySQL Connector ODBC 5.1
°²×°µ½ÎÒ»úÆ÷ÉÏÕâÑùµÄÂé·³ÖÐÈ¥£¬ÒòΪÎÒ¸æËßÄ㣬¼ÙÈôÎÒ˵µÄ¶ÔµÄ»°£¬Intrepid »¹µÄiodbcµÄ°æ±¾¶Ôthe MySQL Connector ODBC 5.1
Ö§³ÖµÄ²»Ì«ºÃ£¬¶øÇÒ·µ»ØµÄÐÅÏ¢²»¹»Ã÷È·£¬Ì¹°×µÄ˵£¬ÎÒËù×öµÄ¾ÍÊǰѺï×Ó·ÅÔÚAugusto’s
±³ÉÏ¡£ËûÄܺܿì°ÑʲôÊÂÇé¶¼ÕûÀíºÃ£¬ÎÒÏëÎҵøÐлËüÁ½´Î£¬¾ÍÒòΪ¸ö¹«¸æ£¬ÎÒÔø¾­Ò²°´ÕÕËûµÄ“Installing Oracle 11gR1 on Ubuntu 8.10 Intrepid Ibex”
ÎÄÕÂÈ¥°²×°oracle ²¿·Ö£¬ÏÖÔÚÈÃÎÒÃÇ˵˵ÐèÇó£¬ÄãÐèÒª°²×°ºÍÅäÖÃÏÂÃæµÄ×é¼þ£¬
Oracle database SE1, SE or EE; ÎÒ°²×°ÊÇ11.1.0.7 £¬10g Ò²Ó¦¸ÃûÎÊÌâ £¬Äã¿ÉÒÔÏÈ¿´¿´ORACLE_HOME/bin
,ËüÀïÃæÓиödg4odbc Îļþ£¬Äܲ»ÄÜÖ´ÐС£
MySQL 4.1, 5.0, 5.1 or 6.0.¸ù¾ÝÎĵµÕâ´Ë¶¼ÊÇConnector ODBC 5.1
. Ö§³ÖµÄ°æ±¾¡£
MySQL
Connector ODBC 5.1
. The Oracle Gateway for ODBC checks/relies on some features, such as the ODBC descriptor, that are not available in 3.51. You can check the associated documentation
and bug 32692
for some details aboutSQLSetDescRec

´´½¨Ò»¸ömysql Àý×ÓÊý¾Ý¿â£¬Óû§£¬Óë±í
   ΪÁËÕâ¸öÀý×ÓÎÒÓÃmysql¿Í»§¶Ë£¬×öÁËÒ»¸ödatabase,user ºÍÒ»¸ö½ÐdemoµÄ±í¡£ÏÂÃæÊÇ´úÂ룺
$ mysql -uroot -p
create database demo character set latin1;
grant all privileges on demo.* to 'demo'@'localhost'
   identified by 'demo' with grant option;
flush privileges;
exit;
$ mysql -udemo -pdemo -Ddemo
create table demo (
&


Ïà¹ØÎĵµ£º

»ñÈ¡SQL Server ¶Ë¿ÚºÅºÍIPµØÖ·

ÔÚÆ½Ê±µÄ¹¤×÷¹ý³ÌÖУ¬×÷ΪDBA½ÇÉ«¹ÜÀíÊý¾Ý¿â£¬Í·ÄÔÖеÄÓ¡ÏóÍùÍùÊÇÊý¾Ý¿âʵÀýÃû³Æ£¬¶ø²»»áÈ¥¹ØÐÄServerµÄIP£¬¶ø×÷ΪDeveloperµÄ½ÇÉ«£¬ËûÃÇÍùÍùÏëÖªµÀÖªµÀServer IpºÍ¶Ë¿ÚºÅ¡£ËùÒÔ£¬DBA»á¾­³£±»Îʼ°µ½£ºXXXʵÀýµÄIPºÍ¶Ë¿ÚºÅÊÇʲô£¿
Õâ¸öÎÊÌ⣬µ±È»ÎÒÃÇ¿ÉÒÔLoginµ½OS²é¿´IP¡¢Ê¹ÓÃÅäÖÆ¹ÜÀí¹¤¾ß»ñÈ¡µ½¶Ë¿ÚºÅ¡£µ«ÊÇ£¬Õâ¸ö·½·¨·Ç ......

×¥SQLÖ´ÐÐÓï¾äʱ¼äµÄ½Å±¾

select sql_text, spid, v$session.program, process
  from v$sqltext, v$session, v$process
  where v$sqltext.address = v$session.sql_address
  and v$sqltext.hash_value = v$session.sql_hash_value
  and v$session.paddr = v$process.addr
  and v$process.spid in (4335);
×¢Ò ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ