DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: character set coversion error

  1. #1
    Join Date
    Feb 2001
    Posts
    83
    Hello guys,

    when i execute the following query, i get the following error. What should i do??

    SQL> insert into ekm.links_old select * from timetrk.links_old@testbv.world;
    insert into ekm.links_old select * from timetrk.links_old@testbv.world
    *
    ERROR at line 1:
    ORA-24812: character set conversion to or from UCS2 failed
    ORA-02063: preceding line from TESTBV.WORLD

    Documentation says to contact oracle customer support, but you guys have any idea why this happens??

    Thanks
    with regards
    Prasanna S

  2. #2
    Join Date
    Apr 2001
    Location
    Louisville KY
    Posts
    295
    I don't have your specific answer (don't recognize your character set UCS2), but I had/have a similar problem when the character set on the source server is newer than the one on the destination. Basically, the older server software did not know about the new character set so could not convert it. In my case, it is a 7.2 HP-UX and a 7.3 MVS.
    Joseph R.P. Maloney, CSP,CDP,CCP
    'The answer is 42'

  3. #3
    Join Date
    Feb 2001
    Posts
    83
    So whats the solution for that ?? How to resolve the problem??
    with regards
    Prasanna S

  4. #4
    Join Date
    Jan 2001
    Posts
    3,134

    Lightbulb

    If they are 2 different databases using different charchter sets you will have to use the import/export utility. Be sure to check the Oracle versions before you do this as well.
    MH

  5. #5
    Join Date
    Apr 2001
    Location
    Louisville KY
    Posts
    295
    try reversing the flow.

    If server A doesn't recognise server B's codes set, instead of pushing from B to A, try pulling from A to B.
    Joseph R.P. Maloney, CSP,CDP,CCP
    'The answer is 42'

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