1 2 Previous Next 16 Replies Latest reply on Sep 4, 2018 3:26 PM by rp0428

    Data import to remote DB (version 12.1) using imp.exe (version 12.2) fails with ora-00942 error




      I am trying to import data onto a remote DB using imp.exe of version 12.2 . The data was exported using export utility exp.exe of version 11.2 . The import is successful if the remote DB is also of 12.2 but if we try to import to 12.1 DB it fails with the following error:


      import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set

      import server uses AL32UTF8 character set (possible charset conversion)

      export client uses AL32UTF8 character set (possible charset conversion)

      IMP-00003: ORACLE error 942 encountered

      ORA-00942: table or view does not exist

      IMP-00023: Import views not installed, please notify your DBA

      IMP-00000: Import terminated unsuccessfully


      Am I missing out something?

        1 2 Previous Next