Re: database links problem

Galaxy Admin wrote at 17-Aug-99 20:15:14 on the subject database links problem:

>I have created a database link by the following statement:

sql>> create database link galaxy connect to galaxyadm identified by
>galaxyadm using 'galaxy';

>Assuming all is well and I have the tnsnames.ora entry and
>user/password is correct.

>When I try to do the following query:

sql>> select emp_at_galaxy
>ERROR:
>ORA-02248: invalid option for ALTER SESSION
>ORA-02063: preceding line from GALAXY

>this error comes up, I do not know what is going on?

>I can only think of a few possibilities:
>- listener.ora file is incorrect
>- tnsnames.ora file entry is incorrect
>- db_domain init parameter is set wrong
>- global_names init parameter is set wrong

Hello Peter,
I observed similar strange error messages when using database links. These messages are quite confusing, because they often have nothing to do with the real error.
Try

select * from emp_at_galaxy

The above error seems to be a result of Oracle's strange parsing habit when using database links.

>Thanks ahead of time for the help.

Hope that helps,
Lothar

>--
>Peter Chan, Nortel Networks email: chanp_at_nortelnetworks.ca

--
Neue Adresse ab 10.07.'99:

Lothar Armbrüster       | lothar.armbruester_at_rheingau.netsurf.de
Hauptstr. 26            | lothar.armbruester_at_t-online.de
D-65346 Eltville        |