Home » RDBMS Server » Server Utilities » expdp fails (10.2.0.5)
expdp fails [message #563097] Wed, 08 August 2012 09:23 Go to next message
new_dba
Messages: 3
Registered: May 2010
Junior Member
expdp userid=system/system01 directory=purge transport_tablespaces=purge dumpfile=purge_data.dmp logfile=purge_exp.log job_name=test

Export: Release 10.2.0.5.0 - 64bit Production on Wednesday, 08 August, 2012 14:12:06

Copyright (c) 2003, 2007, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, 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
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist
ORA-00942: table or view does not exist


Re: expdp fails [message #563120 is a reply to message #563097] Wed, 08 August 2012 18:14 Go to previous messageGo to next message
BlackSwan
Messages: 22554
Registered: January 2009
Senior Member
>expdp userid=system/system01 directory=purge transport_tablespaces=purge dumpfile=purge_data.dmp logfile=purge_exp.log job_name=test


what exactly did you expect to be exported using command above?
Re: expdp fails [message #563132 is a reply to message #563120] Thu, 09 August 2012 00:36 Go to previous messageGo to next message
new_dba
Messages: 3
Registered: May 2010
Junior Member
the tablespace - purge
Re: expdp fails [message #563141 is a reply to message #563132] Thu, 09 August 2012 01:08 Go to previous messageGo to next message
Michel Cadot
Messages: 58641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
answer is it that BlackSwan to?

Regards
Michel
Re: expdp fails [message #563156 is a reply to message #563097] Thu, 09 August 2012 01:52 Go to previous message
Michel Cadot
Messages: 58641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Answer from "Denis ♔Ukraine♔" at http://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=53820&SkipA=0#172914:

Quote:
Answer: This ORA-31626 error may be a bug. See MOSC note 549781.1 for details.


Regards
Michel
Previous Topic: SQLLDR..Delimited file: bypass unwanted data fields (2 threads merged by bb)
Next Topic: Restore
Goto Forum:
  


Current Time: Fri Aug 01 05:05:43 CDT 2014

Total time taken to generate the page: 0.28426 seconds