| DB Link [message #64453] |
Mon, 31 January 2005 01:07  |
priti
Messages: 18
Registered: July 2002
|
Junior Member |
|
|
Hi All,
I need to cr8 a dblink btw oracle 7.3.3.5 to oracle 8.1.7 database, plz let me know how to create a db link...i hav never done this before
Thanks in Advance
Regards
Priti
|
|
|
|
| Re: DB Link [message #64454 is a reply to message #64453] |
Mon, 31 January 2005 01:11  |
Sreedhar Reddy
Messages: 55
Registered: January 2002
|
Member |
|
|
First create the TSNNAME
then
create public database link lnk7.3 connect to '<username>' identified by '<password>' using '<tsnname>'
then issues the sql statements;
ex: select * from emp@lnk7.3
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
