Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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