This discussion is archived
6 Replies Latest reply: Mar 1, 2013 10:40 AM by user3636719 RSS

Export: ORA-39097 ORA-39065 ORA-01403

user3636719 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points