Re: DBlink problem

From: Luc Gyselinck <Luc.Gyselinck_at_nospampandora.be>
Date: Wed, 12 Jan 2005 22:33:18 GMT
Message-ID: <OAhFd.29177$m24.2665502@phobos.telenet-ops.be>

Try it like this:

create database link test_link connect to current_user using '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<remote_ip_address>)(PORT=<remote _listener_port>))(CONNECT_DATA=(SID=<remote_service_name>)))'

Example:

SQL> create database test_link
  2 connect to scott
  3 identified by tiger using
  4
'(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=infotex01)(PORT=1521))(CONNECT_DA TA=(SID=ORCL)))'
  5 /

Database link created.

SQL> descr emp_at_test_link

 Name                                      Null?    Type
 ----------------------------------------- -------- ------------------------
----
 EMPNO                                     NOT NULL NUMBER(4)
 ENAME                                              VARCHAR2(10)
 JOB                                                VARCHAR2(9)
 MGR                                                NUMBER(4)
 HIREDATE                                           DATE
 SAL                                                NUMBER(7,2)
 COMM                                               NUMBER(7,2)
 DEPTNO                                             NUMBER(2)

SQL> "Alberto" <albert_dabrowski_at_yahoo.co.uk> wrote in message news:d4e9d417.0501121321.115d5269_at_posting.google.com...
> Hi,
> I wanted to create dblink (Oracle 8i) to resolve problem with
> connecting to the remote database without configuring tnsnames.ora,
> but it seems that I cannot do this.
> Is there any solution that I can connect to the remote database from
> local db or by using sqlplus without configuring tnsnames.ora?
>
> I have tried:
> create database link test_link connect to current_user using
> 'T:<remote_ip_address>:<remote_service_name>';
> but it does not work.
>
> Thanks in advance,
> Albert
Received on Wed Jan 12 2005 - 16:33:18 CST