This discussion is archived
2 Replies Latest reply: Jul 2, 2009 7:22 AM by 277993 RSS

import error character set conversion

449370 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    Import terminated successfully without warnings.
    where's the error?
  • 2. Re: import error character set conversion
    277993 Journeyer
    Currently Being Moderated
    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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points