Datapump Export Gives Ora-31626 and Ora-942 errors
Oracle 11.2.0.2 on Linux x86-64
expdp system/pwd tables=scott.testtable directory=DATA_PUMP_DIR file=exp.dmp log=exp.log job_name=test_exp
Export: Release 11.2.0.2.0 - Production on Tue Dec 4 12:48:49 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
ORA-31626: job does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
expdp system/pwd tables=scott.testtable directory=DATA_PUMP_DIR file=exp.dmp log=exp.log job_name=test_exp
Export: Release 11.2.0.2.0 - Production on Tue Dec 4 12:48:49 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
ORA-31626: job does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
2