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

Thread: Export Character Set

  1. #1
    Join Date
    Feb 2002
    Posts
    41

    Question

    I've altered both Database's character set them to:

    NLS_CHARACTERSET WE8ISO8859P1
    NLS_NCHAR_CHARACTERSET WE8ISO8859P1

    Yet export defaults to US7ASCII, and ends in the following message:

    Export done in US7ASCII character set and WE8ISO8859P1 NCHAR character set server uses WE8ISO8859P1 character set (possible charset conversion).

    Problem comes when trying to import that file in my NT, which uses WE8ISO8859P1, I' getting an IMP-0069 error stating that it could not convert to environment character set's handle.

    Is there a way to change export character set from USA7ASCII to WE8ISO8859P1, and or any other solution to the export/import problem described above.

    TIA.

  2. #2
    Join Date
    Oct 2001
    Location
    Buffalo, NY
    Posts
    46
    your database and your NLS environment variables need to be set to the same character set. check your NLS environment settings to ensure they're set to the WE character set.
    Tim Hussar

  3. #3
    Join Date
    Jan 2001
    Location
    St. Louis. MO
    Posts
    151
    The reason why you are getting that messate is because the character set of your database is different from the character set where you are running your export program. If you are in UNIX, it could be that the character set of the UNIX server is US7ASCII, that is why when you do an export oracle has to convert it to US7ASCII.

  4. #4
    Join Date
    Feb 2002
    Posts
    41
    Done.

    I just added the following line to oracle's .bash_profile:

    export NLS_LANG=american.WE8ISO8859P1


    Thanks.

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