oracle dblink mysql

网文档 ：

 

http://download.oracle.com/docs/cd/B28359_01/gateways.111/b31042/configodbc.htm

 

listener.ora 

(SID_DESC =
     	(SID_NAME = test)
      (ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
      (PROGRAM = hsodbc)
)

tnsnames.ora

test= 
(DESCRIPTION = 
  (ADDRESS_LIST = 
  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) 
  ) 
  (CONNECT_DATA = (SID = test))
  	(HS = OK) 
  )
)  

init.ora

HS_FDS_CONNECT_INFO = test
HS_FDS_TRACE_LEVEL = 0
      )