2 Replies Latest reply: Jul 2, 2009 9:22 AM by 277993 RSS

    import error character set conversion

    449370
      import done in US7ASCII character set and AL16UTF16 NCHAR character set
      import server uses AL32UTF8 character set (possible charset conversion)
      export client uses WE8ISO8859P1 character set (possible charset conversion)
      Import terminated successfully without warnings.

      how to resolve this

      importinng into linux machine
        • 1. Re: import error character set conversion
          591186
          Import terminated successfully without warnings.
          where's the error?
          • 2. Re: import error character set conversion
            277993
            import done in US7ASCII character set and AL16UTF16 NCHAR character set
            import server uses AL32UTF8 character set (possible charset conversion)
            export client uses WE8ISO8859P1 character set (possible charset conversion)
            Import terminated successfully without warnings.
            Your import was successful. However, there are a few things you need to note from the top of the import log. It is advisable to use correct NLS settings when doing export/import to avoid data corruption/loss. That idea is to ensure you set the correct NLS setting (NLS_LANG) at the client before running exp or imp. In some cases, the setting does not matter because the different character sets can go together.

            In this case, I would not worry about it.