Re: database link as user PUBLIC

From: Steve McDaniels <steve.mcdaniels_at_sierra.com>
Date: Tue, 2 Jan 2001 14:37:58 -0800
Message-ID: <92tlal$gor$1@spiney.sierra.com>

Start by establishing an SQL*Plus session on the remote system, taking note of the username and password you are using to connect.

THEN create database link SID.DOMAIN.COM
connect to <username>
identified by <password>
using '<tnsnames entry>'
/

THEN select table_name from user_tables_at_SID.DOMAIN.COM /

"bernhard labus" <bernhard.labus_at_home.ins.de> wrote in message news:3a51ea59$0$8783$4dbef881_at_businessnews.de.uu.net...
> Hello everybody,
>
> maybe someone knows:
> How can I create a database link as user PUBLIC,
> ***I don't mean*** a public database link.
>
> I am on database A and want to query a public synonym on database B.
> when I try
> create database link LINKTOBasPUBLIC connect to PUBLIC using 'B',
> ORA-00987: missing or invalid username(s)
> or
> create database link LINKTOBasPUBLIC connect to PUBLIC identified
externally
> using 'B',
> ORA-00987: missing or invalid username(s)
>
> Thanx in advance
> Bernhard
>
>
Received on Tue Jan 02 2001 - 16:37:58 CST