You are making a confusion here.
To be able to access remote servers in Oracle you use a DB-LINK, not a
SQL*Net (wich is just used to make a single, normal connection to an Oracle
Server).
Carlos Felipe Zirbes
DBServer Assessoria em Sistemas de Informação
E-mail: carlosz@dbserver.com.br
Fone: (51) 3342-8055
Fax: (51) 3342-4838
-----Original Message-----
From: Roderick A. Anderson [mailto:raanders@tincan.org]
Sent: Wednesday, September 12, 2001 11:36 AM
To: Justin Clift
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Ridicolus Postgresql review
On Wed, 12 Sep 2001, Justin Clift wrote:
> Hey guys,
>
> Does anyone know anything about this SQL*Net compatible thing which we
> are supposed to be developing according to the article?
Haven't read the article but from my Oracle days SQL*Net is the thingy
that lets you connect to multiple instances/databases from one
session(?).
In fact if memory servers me correct it allows RI based on tables on
a remote server. There was a command that allowed you to create a
database connection in the current 'instance' to other instances or
remote databases.
Cheers,
Rod
--
A small clue and no money
will get you further than
lots of money and no clue.
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html