3 Replies Latest reply: Mar 3, 2013 7:48 PM by Dean Gagne-Oracle RSS

    expdp got error

    GolfStar03
      Database=10.2.0.4
      when expdp (full or schemas) i got error:

      ORA-39125: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_METADATA while calling DBMS_METADATA.FETCH_XML_CLOB [TABLE_DATA:"WSE"."WSE_REPORTS"]
      ORA-31642: the following SQL statement fails:
      BEGIN "SYS"."DBMS_SCHED_EXPORT_CALLOUTS".SCHEMA_CALLOUT(:1,1,1,'10.02.00.04.00'); END;
      ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
      ORA-06512: at "SYS.DBMS_METADATA", line 907
      ORA-06502: PL/SQL: numeric or value error: character string buffer too small

      ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
      ORA-06512: at "SYS.KUPW$WORKER", line 6313
        • 1. Re: expdp got error
          Srini Chavali-Oracle
          Did this ever work successfully ? Pl see if this MOS Doc can help

          EXPDP FAILS WITH ORA-39125 ORA-31642 DBMS_SCHED_EXPORT_CALLOUTS [ID 445291.1]


          HTH
          Srini
          • 2. Re: expdp got error
            Osama_Mustafa
            user13344656 wrote:
            Database=10.2.0.4
            when expdp (full or schemas) i got error:

            ORA-39125: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_METADATA while calling DBMS_METADATA.FETCH_XML_CLOB [TABLE_DATA:"WSE"."WSE_REPORTS"]
            ORA-31642: the following SQL statement fails:
            BEGIN "SYS"."DBMS_SCHED_EXPORT_CALLOUTS".SCHEMA_CALLOUT(:1,1,1,'10.02.00.04.00'); END;
            ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
            ORA-06512: at "SYS.DBMS_METADATA", line 907
            ORA-06502: PL/SQL: numeric or value error: character string buffer too small

            ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
            ORA-06512: at "SYS.KUPW$WORKER", line 6313
            Adding to Srini could you please post export/import command that you use
            • 3. Re: expdp got error
              Dean Gagne-Oracle
              I would be curious if you had a version parameter or is this was a network job.

              Dean