Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Posts
    49

    Unanswered: NLS_LANG conversion

    hi everybody,
    i have to migrate a db from Oracle 7.3 on a Digital Solaris to Oracle 8i on a SUN with Solaris 8. i made an export and i'm trying to import the instance on the new db server Oracle 8i.
    I got this error:

    IMP-00016: required character set conversion (type 1 to 871) not supported
    IMP-00000: Import terminated unsuccessfully

    i know this i because of different NLS_LANG values on the two db and i'm supposed to set the same NLS_LANG value i have on the old db server. but... typing "env" on the machine with the old db i can't find a NLS_LANG parameter (only KBD_LANG=US or LANG=C).
    then:
    - how can i know what's the NLS_LANG value on the oracle 7.3 db?
    - once i got it, is it enough to type
    set NLS_LANG = ****
    in the .profile file of the oracle user or am i supposed to perform any other operation to be able to have my import working correctly? i mean... what should i do to have my oracle 8i instance to have a new NLS_LANG value set?

    any kind of suggestion will be greatly appreciated.

    Thank you very much!

    Matte

  2. #2
    Join Date
    Sep 2003
    Location
    The Netherlands
    Posts
    311
    hi,

    most of the times imp tells u what character set was used exporting the database. Yes it should be enough to change the nls_lang in your session to the one needed.

    Hope this helps
    Edwin van Hattem
    OCP DBA / System analyst

  3. #3
    Join Date
    Aug 2003
    Posts
    49
    Originally posted by evanhattem
    hi,

    most of the times imp tells u what character set was used exporting the database. Yes it should be enough to change the nls_lang in your session to the one needed.

    Hope this helps
    Thank you very much,
    i will try!

    Best regards,
    Matte

Posting Permissions

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