Re: Need help creating database link

From: <rock_cogar_at_my-deja.com>
Date: Tue, 17 Aug 1999 20:36:14 GMT
Message-ID: <7pch3t$in5$1@nnrp1.deja.com>

Can you simplify the syntax by removing PUBLIC and get it to work ?

In article <37B9B492.47D890F8_at_americasm01.nt.com>, "Gin, Jeannine (EXCHANGE:QUAL:7S02)" <jgin_at_americasm01.nt.com> wrote:
> I am using the following syntax to create a database link:
>
> create public database link mydatabase connect to myuser identified by
> mypassword using 'databasename'
>
> I get the following error message:
>
> ORA-02248: invalid option for ALTER SESSION
> ORA-02063: preceding line from MYDATABASE
>
> I am executing this command as system on Oracle 7.3.3.
>
> thanks in advance,
>
> Jeannine
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Aug 17 1999 - 15:36:14 CDT