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 -> Re: database link

Re: database link

From: Sebastian Rehm <Sebastian.Rehm_at_de.bosch.com>
Date: Fri, 23 Feb 2001 13:27:23 +0100
Message-ID: <3A96572B.821573E2@de.bosch.com>

Hi Christophe,

Seems to be a GLOBAL_NAME thing:
Try removing line GLOBAL_NAMES=TRUE from initox4i.ora of your Database ox4i, or NAME the Database-Link ORACLE

( create database link ORACLE connect to login identified by password using 'portable.society' )

Sebastian

christophe schrieb:
>
> then, i used the command: create database link mine connect to login
> identified by password using 'portable.society'
> the link was created
> but as i tried to read a table in mgv8 from ox4i using the command:
> select * from table1_at_mine,
> i got the error:
> ORA-02085: database link mine connecting to oracle
Received on Fri Feb 23 2001 - 06:27:23 CST

Original text of this message

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