3 Replies Latest reply: Dec 6, 2012 7:53 AM by Dean Gagne-Oracle RSS

    how to fix datapump error ORA-39062

    956054
      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