Re: Trigger does not work after client upgrade to 8.1.7
From: Frank <fbortel_at_home.nl>
Date: Fri, 03 May 2002 22:05:09 +0200
Message-ID: <3CD2ED75.4080406_at_home.nl>
>
> No Lobs Involved here, but the problem seems to be the database links
> I use.
>
>
> I created the links with
>
> CREATE DATABASE LINK mcc
> CONNECT TO user IDENTIFIED BY "****"
> USING 'MCC';
>
> now what I get when I do a select * from user_db_links
>
> is
> db_link host
> mcc.name1-name2.com mcc.name1-name2.com
>
> and "-" is not allowed in database names
>
> If I try to create a synonym I get an ORA-02083 (database name has
> illegal character 'string')
>
> This domain is not specified in my client sqlnet.ora
> So this must be set somwhere on the server.
Date: Fri, 03 May 2002 22:05:09 +0200
Message-ID: <3CD2ED75.4080406_at_home.nl>
justin wrote:
> On Tue, 30 Apr 2002 19:51:49 +0200, Frank <fbortel_at_home.nl> wrote:
>
>
<snip previous suggestions>
>>Any LOB's involved here? There are several bugs known >>with LOB's and triggers - search metalink >>
>
> No Lobs Involved here, but the problem seems to be the database links
> I use.
>
>
> I created the links with
>
> CREATE DATABASE LINK mcc
> CONNECT TO user IDENTIFIED BY "****"
> USING 'MCC';
>
> now what I get when I do a select * from user_db_links
>
> is
> db_link host
> mcc.name1-name2.com mcc.name1-name2.com
>
> and "-" is not allowed in database names
>
> If I try to create a synonym I get an ORA-02083 (database name has
> illegal character 'string')
>
> This domain is not specified in my client sqlnet.ora
> So this must be set somwhere on the server.
>
> I can create and use the link in pure sql though.
> But it seems I can not create a synonym on it or use it with the
> client version 8.1.7.3, if I revert to 8.0.5 all works again.
> The server is 8.1.6.3
>
> Where is this domain parameter specified that is appended to the
> links?
> If I change it what else will be affected?
Don't know - you know your situation.
>
> thanks
>
> justin
>
>
>
Received on Fri May 03 2002 - 22:05:09 CEST