db link from 8i db to 10g db

[yxez]

Hi Friends,

Is there a problem or bug for database link from 8i db connecting to 10g ?

I created a db link like this:

on 8i db (system)

sql> create public database link 10g_pub_lnk connect to scott
identified by tiger using 'ora10g';

database link created.

sql> select * from tab@10g_pub_lnk;

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


Is there a work-around here?

Thanks a lot

[waitecj]

It just means that your NLS characterset is different in your source database to your destination database. Execure this on both sides:

select * from v$nls_parameters where parameter like '%CHARACTERSET%';

Not an issue with database links as such.

[yxez]

How can i make them the same nls char set?

[waitecj]

You can change your characterset with an alter database command, but you need to know exactly what the consequences are in doing so, as it can affect how some data might be stored and displayed. Note 276914.1 explains things quite nicely, though there are other examples about if you google.