1 Reply Latest reply on Oct 29, 2012 5:17 PM by Raj Jamadagni

    expdp estimate size of dump file

      i`m trying to estimate size of dump file with expdp
      expdp system/*** schemas=FLAG logfile=DATA_PUMP_DIR:full1.log estimate_only=y
      and i`m getting this error:
      ORA-39125: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_METADATA while calling DBMS_METADATA.FETCH_XML_CLOB [TABLE_DATA:"FLAG"."TAB_NAME"]
      ORA-31642: the following SQL statement fails:
      ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
      ORA-06512: at "SYS.DBMS_METADATA", line 907
      ORA-20001: You cannot perform DDL operation - no access (DROP TABLE SCHEDULER$_PROGRAM_ARG)

      ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
      ORA-06512: at "SYS.KUPW$WORKER", line 6313

      ----- PL/SQL Call Stack -----
      object line object
      handle number name
      0x45e0cf480 15032 package body SYS.KUPW$WORKER
      0x45e0cf480 6372 package body SYS.KUPW$WORKER
      0x45e0cf480 2396 package body SYS.KUPW$WORKER
      0x45e0cf480 6944 package body SYS.KUPW$WORKER
      0x45e0cf480 1314 package body SYS.KUPW$WORKER
      0x45d78bca0 2 anonymous block

      Job "SYS"."SYS_EXPORT_SCHEMA_01" stopped due to fatal error at 17:10:42

      does any one knows what does it mean or how to fix it?
      i`m using oracle 10gR2. Servers Red Hat Enterprise Linux Server release 5.8

      BR Flag