defining a db link from a 8.1.7.3.0 to a 9.2.0.2.0 db without ORA-24365 ?

hello,

I have 2 DB servers, one in 9i 9.2.0.2.0 using UTF16AL32 character set.
The other one is a 8.1.7.3.0 with UTF8 character set.

I need to define a db link between this 2 db, from the 8i to the 9i.

Unfortunately they don't have same characters set, the 9i is above the 8i, so I guess that may be why I got those errors when I try to SELECT a table using the db link :

select * from game_at_My9i_DB;

ERROR at line 1:
ORA-02068: following severe error from My9i_DB ORA-24365: error in character conversion

the db link definition :
create database link My9i_DB
connect to myUser9i identified by myPaswd9i using
'(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=myhost9i)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=my9iDBservice)))'

I tried to do the same in the opposite direction (from 9i to 8i), and in that way it works fine, so I guess it must come either from a characters set issue, or a downgrade trouble.

So please if you could help ...
Thanks !
Patrice Received on Tue Mar 04 2003 - 08:55:01 CST