4 Replies Latest reply on Feb 15, 2010 12:08 PM by Charlov

    EXP-00056: ORACLE error 942 encountered while exporting full database

    440304
      I get the following error message when i try to export the production database in full mode logged in as SYS.

      Export: Release 9.0.1.1.1 - Production on Wed Mar 16 15:23:23 2005

      (c) Copyright 2001 Oracle Corporation. All rights reserved.
      Connected to: Oracle8i Release 8.1.7.1.1 - Production
      JServer Release 8.1.7.1.1 - Production

      EXP-00056: ORACLE error 942 encountered
      ORA-00942: table or view does not exist

      EXP-00000: Export terminated unsuccessfully



      The following message in the export log doesnt explain anything either
      Connected to: Oracle8i Release 8.1.7.1.1 - Production
      JServer Release 8.1.7.1.1 - Production
      EXP-00056: ORACLE error 942 encountered
      ORA-00942: table or view does not exist
      EXP-00000: Export terminated unsuccessfully

      thanks,
      Preeti