Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-31634 and 31664 when expdp

mantis308Jun 10 2011 — edited Jun 10 2011
G:\>expdp parfile=g:\datapump\expfull_dp.par


Export: Release 10.2.0.4.0 - 64bit Production on Friday, 10 June, 2011 10:24:23

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

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit
Production
With the OLAP, Data Mining and Real Application Testing options
ORA-31634: job already exists
ORA-31664: unable to construct unique job name when defaulted


When I run select job_name, state from dba_datapump_jobs; I get a bunch of jobs in a NOT RUNNING state... as such:


JOB_NAME STATE
SYS_EXPORT_FULL_38 NOT RUNNING
SYS_EXPORT_FULL_26 NOT RUNNING

101 rows selected.

Totally lost... can't drop them, Oracle tells me it's not a valid table/view.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 8 2011
Added on Jun 10 2011
#general-database-discussions
3 comments
5,893 views