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

Thread: Charecter set problem

  1. #1
    Join Date
    Aug 2001
    Posts
    56

    Charecter set problem

    Export done at solaris server, I am trying to import in same version but in Windows 2000 server.

    it is given charcter set problem. can i change charcter set, I an not able to find out NLS_charcterset parameter in init.ora file.

    can anyone suggest

    Import: Release 8.1.7.0.0 - Production on Thu Dec 19 20:41:00 2002

    (c) Copyright 2000 Oracle Corporation. All rights reserved.


    Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
    With the Partitioning option
    JServer Release 8.1.7.0.0 - Production

    Import file: EXPDAT.DMP > E:\Saco\algo.dmp

    Enter insert buffer size (minimum is 8192) 30720>

    Export file created by EXPORT:V08.01.07 via conventional path
    import done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character set
    export server uses WE8ISO8859P15 NCHAR character set (possible ncharset conversi
    on)
    Anuj
    India

  2. #2
    Join Date
    Dec 2002
    Location
    Granite City , Illinois
    Posts
    4

    Charater Set

    Anuj ,

    The character set is initially set in the "Create Database" statement,before doing an export make sure your OS env variable for NLS_LANG, you can use the following script to find what character set is set for your database:

    select 'export NLS_LANG="'||char_date.value||'_'
    ||char_iso_value.value||'.'
    ||char_char_value.value||'"'
    from v$nls_parameters char_date,
    (select value
    from v$nls_parameters
    where parameter='NLS_ISO_CURRENCY') char_iso_value,
    (select value
    from v$nls_parameters
    where parameter = 'NLS_CHARACTERSET') char_char_value
    where char_date.parameter = 'NLS_DATE_LANGUAGE';

    ALSO NOTE: In order to change Character Set you have to RECREATE DB!!

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    WE8ISO8859P15 is WE8ISO8859P1 but supports EURO sign, that´s just a warning, if you want to avoid it then set your NLS_LANG to WE8ISO8859P1

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