DB Link

[mike777]

Hello.
Has anyone had any success using a db link to access another database (i.e., a different type of database, in this case Borland Interbase)?
Thank you.
-Mike

 

[Turkbear]

Hi,
did you read the docs on heterogeneous connections?

For Oracle 8i you can look here:

http://download-west.oracle.com/docs/cd/A87860_01/doc/network.817/a76933/advcfg.htm#463777

For 9i ( much easier, it seems) look here:

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96544/preface.htm#971622

hth,


PS you may need to register with Oracle's Technet - do so, it is free, they respect your privacy, do not spam, and it is a valuable resource.

 

[Scunningham99]

heres an example

#THIS DOES NOT NEED AN ENTRY IN TNSNAMES.ora FILE

CREATE DATABASE LINK DEMO_LINK.WORLD
CONNECT TO APPS
IDENTIFIED BY APPS
USING '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=lsi)(PORT=1523))(CONNECT_DATA=(SID=DEMO)))'

Sy UK

 

[Turkbear]

Hi,
That example might work to connect to an Oracle instance called 'DEMO' , but it will not connect to any non-Oracle database, which is what Mike777 wanted to do.