1 2 Previous Next 16 Replies Latest reply on Jul 30, 2007 6:26 AM by gl*325468*48

    export problen EXP-00008: ORACLE error 942 encountered

    gl*325468*48
      oracle :9.2.0.6
      os : linux
      problem : export

      I just installed oracle, without creating the database. (No database created)
      I just want to take an export backup of other server SID. I configured tnsnames.ora for the other. tnsping works fine. I connect sqlplus also works fine
      ------------------------------------------------------------------------------------------------------
      [oracle@support-ge export]$ sqlplus GEMINI1/GEMINI1@E5GEDB1

      SQL*Plus: Release 9.2.0.6.0 - Production on Thu Jul 26 18:33:50 2007

      Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


      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

      SQL> select name from v$database;

      NAME
      ---------
      E5GEDB1
      ---------------------------------------------------------------------------------------------------
      Now I am trying to take export of this users using export

      I am getting the error

      exporting pre-schema procedural objects and actions
      . exporting foreign function library names for user GEMINI1
      . exporting PUBLIC type synonyms
      . exporting private type synonyms
      . exporting object type definitions for user GEMINI1
      EXP-00008: ORACLE error 942 encountered
      ORA-00942: table or view does not exist
      EXP-00024: Export views not installed, please notify your DBA
      EXP-00000: Export terminated unsuccessfully

      what is my mistake ?, do I need a db to take export ?
      . oraenv oracle and home were set

      How to take export
        1 2 Previous Next