Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    2

    Unanswered: Newbie with an import problem

    Hi everyone,
    During an import process I received the following error :

    SSGDS001@eusadba1> imp dirdbo2/dirdbo2 full=y
    file=/tmp/Delivery2-150903.dmp
    Import: Release 9.2.0.1.0 - Production on Mon Sep 15 13:27:52 2003
    Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit
    Production
    With the Partitioning, OLAP and Oracle Data Mining options
    JServer Release 9.2.0.1.0 - Production
    Export file created by EXPORT:V09.02.00 via conventional path
    Warning: the objects were exported by ROTEM2, not by you
    import done in US7ASCII character set and AL16UTF16 NCHAR character set
    import server uses WE8ISO8859P15 character set (possible charset
    conversion)
    export client uses WE8MSWIN1252 character set (possible charset conversion)
    export server uses UTF8 NCHAR character set (possible ncharset conversion)

    Although the import ended succesfully (and the db up till now is functional), I would like to know whether this character set differences may pose a problem and if so, how do I remedy it ?
    Thanks.

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

    the messages are only warnings. But what they mean say is that the export was done using a different characterset than import. So, since there are possible characters in the first set which are not present in the second, character conversion will be done if possible. If not possible, import fails. Although the import ended succesfully and all functionality is available, it might be possible that some data will be different after the import.
    It shows that you used the US7ASCII, which does not support all characters in Western Europe, especially things like special charcters on top of e or a etc.
    To avoid this problem, check the character set useed by the database from whichthe export was takenand before importing change the NLS_LANG to that of the exported database. Like this

    NLS_LANG=american_america.WE8ISO8859P15

    imp system/amaneger .......

    Hope this helps.

    Edwin

Posting Permissions

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