db link from 8i db to 10g db
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: db link from 8i db to 10g db

  1. #1
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681

    db link from 8i db to 10g db

    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
    Behind The Success And Failure Of A Man Is A Woman

  2. #2
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    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.
    Assistance is Futile...

  3. #3
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    How can i make them the same nls char set?
    Behind The Success And Failure Of A Man Is A Woman

  4. #4
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    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.
    Assistance is Futile...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width