10 Replies Latest reply: May 17, 2012 7:42 PM by Srini Chavali-Oracle RSS

    imp-00008: unrecognized statement in the export file

    937574
      Hi All,

      I am trying to import an export from Oracle 8.1.7 source system to Oracle 11.2 using imp . I am getting the following errors may times during the import process.

      imp-00008: unrecognized statement in the export file

      The character set of Source data base is WE8DEC and the character set of target data base is WE8MSWIN1252 and i get the below statement during the start of the import


      import done in US7ASCII character set and AL16UTF16 NCHAR character set
      import server uses WE8MSWIN1252 character set (possible charset conversion)
      export client uses WE8DEC character set (possible charset conversion)
      export server uses WE8DEC NCHAR character set (possible ncharset conversion)


      The error imp-00008: unrecognized statement in the export file is it due to the Oracle version compatibility or due to Character set compatibility issue.

      I tried to create a new Database on same Oracle sever and i cant find WE8DEC in the list of character set to choose. Please help me on how to proceed.


      Regards,
      alen.