6 Replies Latest reply: Mar 1, 2013 12:40 PM by user3636719 RSS

    Export: ORA-39097 ORA-39065 ORA-01403

    user3636719
      Hello Gurus

      I am getting below error for export,
      nohup expdp system/password@BROOM SCHEMAS=CWA directory=DATAPUMP dumpfile=broom.dmp logfile =broom.log  &
      Error
      Export: Release 11.2.0.3.0 - Production on Fri Mar 1 11:40:04 2013
      
      Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
      ;;;
      Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
      With the Partitioning, OLAP, Data Mining and Real Application Testing options
      ORA-39097: Data Pump job encountered unexpected error 100
      ORA-39065: unexpected master process exception in DISPATCH
      ORA-01403: no data found
      Version
      11:46:49 : 01-MAR-13 @ SYS (TAMCW2) SQL>select * from v$version;
      
      BANNER
      --------------------------------------------------------------------------------
      Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
      PL/SQL Release 11.2.0.3.0 - Production
      CORE    11.2.0.3.0      Production
      TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production
      NLSRTL Version 11.2.0.3.0 - Production