1 2 Previous Next 17 Replies Latest reply on Dec 28, 2010 12:39 AM by ggiulian

    IMP-00003: ORACLE error 942 encountered

    472194
      Hi All,

      I have exported a schema in Oracle 9i and imported into Oracle 10g. But I got error as below. Kindly check if anyone have any idea about this error. Thanks.

      Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
      With the Partitioning, OLAP, Data Mining and Real Application Testing options

      Export file created by EXPORT:V09.02.00 via conventional path
      import done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set
      export client uses US7ASCII character set (possible charset conversion)
      . importing OMEDATA's objects into OMEDATA
      . . importing partition "ALARM_HISTORY":"PART_2005_06_26" 23846 rows imported
      . .
      . .
      . .
      . . importing partition "ALARM_HISTORY":"PART_2008_07_20" 20010 rows imported
      . . importing partition "ALARM_HISTORY":"PART_2008_07_27" 16547 rows imported
      . . importing partition "ALARM_HISTORY":"PART_MAX" 11939 rows imported
      IMP-00003: ORACLE error 942 encountered
      ORA-00942: table or view does not exist
      . importing OMEDATA's objects into OMEDATA
      . . importing table "ALARM_HISTORY_ARCHIVE" 0 rows imported
      . importing OMEDATA's objects into OMEDATA
      . . importing table "ALARM_LOG" 0 rows imported
      . . importing table "ALARM_REPORT" 2127193 rows imported
      . . importing table "ALARM_SOURCES" 4 rows imported
      . . importing table "CALENDAR" 105 rows imported
      . . importing partition "CTOOL_STATE_HISTORY":"PART_MAX" 0 rows imported
      IMP-00003: ORACLE error 942 encountered
      ORA-00942: table or view does not exist
      IMP-00003: ORACLE error 942 encountered
      ORA-00942: table or view does not exist
      IMP-00003: ORACLE error 942 encountered
      ORA-00942: table or view does not exist

      Regards,
      Tarman
        1 2 Previous Next