This discussion is archived
3 Replies Latest reply: Dec 6, 2012 5:53 AM by Dean Gagne RSS

how to fix datapump error ORA-39062

956054 Newbie
Currently Being Moderated
Hi,
i am new in oracle DBA and ischeduled expdp for a schemas and it was working fine but after 4month, today i checked directory where .dmp and .log file save but i didn't get ant backup file then i checked alter log and there are a ora message
DM00 started with pid=81, OS id=9505, job TEST.SYS_EXPORT_SCHEMA_01
opidrv aborting process DM00 ospid (9505) as a result of ORA-447
then did expdp manual
$ expdp TEST/TEST DIRECTORY=DATAPUMP_DIR DUMPFILE=TESTBKP.DMP LOGFILE=TESTEXP.DMP SCHEMAS=TEST PARALLEL=3
and got error:
Export: Release 11.2.0.1.0 - Production on Wed Dec 5 16:29:58 2012

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-31626: job does not exist
ORA-31637: cannot create job SYS_EXPORT_SCHEMA_01 for user TEST
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 1569
ORA-39062: error creating master process DM00
ORA-39107: Master process DM00 violated startup protocol. Master error:
ORA-06533: Subscript beyond count
please guide me why this error coming and how to fix this.

Thanks in advanced

Regrds
amit

Legend

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