Re: Need help creating database link

A copy of this was sent to "Gin, Jeannine (EXCHANGE:QUAL:7S02)" <jgin_at_americasm01.nt.com>
(if that email address didn't require changing) On Tue, 17 Aug 1999 15:14:26 -0400, you 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

Is it possible you have set the NLS_DATE_FORMAT in your init.ora file?

If so:

Set any NLS parameter to use double quote marks in the initSID.ora file.  

       Example: NLS_DATE_FORMAT = "DD/MON/YYYY"  

The environment is then read as the literal between the double quotes.  

When environment variables are sent across the link, NLS_DATE_FORMAT is sent as ''''NLS_DATE_FORMAT = DD/MON/YYYY'''' due to using single quote marks in the initSID.ora file.

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Tue Aug 17 1999 - 14:58:51 CDT