Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> HELP: DBLINK SYNTAX

HELP: DBLINK SYNTAX

From: <coopman_at_ix.netcom.com>
Date: Wed, 4 Aug 1999 18:40:03 -0400
Message-ID: <7oafek$mi2@dfw-ixnews6.ix.netcom.com>


If anyone can help, I'd appreciate it-

I am having trouble tracking down the following DBLINK syntax variation in Oracle docs

for instance:

select count(*) from SOME_TABLE@!

(that's at - @ - exclamation point - ! -)

I suspect this involves some reference to a 'default' dblink or something similar

when I try it myself, I get

select * from mytable@!

                       *

ERROR at line 1:
ORA-02019: connection description for remote database not found

(this is using SQL*Plus w/ Oracle 8.1.5 on NT 4.0)

Is '!' a legal DBLINK name that can be defined?

Thanx in advance,

Marc Received on Wed Aug 04 1999 - 17:40:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US