5 Replies Latest reply: Apr 14, 2014 8:32 AM by rakesh1947 RSS

    expdp error

    955912

      Hi ;

       

      $ expdp directory=dpbkp dumpfile=expfull.dmp logfile=expfull.log full=y

      full=y

      Export: Release 11.2.0.1.0 - Production on Wed Apr 9 16:55:05 2014

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

      Username: dvn

      Password:

      Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production

      With the Partitioning, OLAP, Data Mining and Real Application Testing options

      Starting "DVN"."SYS_EXPORT_FULL_04":  dvn/******** directory=dpbkp dumpfile=expfull.dmp logfile=expfull.log full=y

      ORA-39126: Worker unexpected fatal error in KUPW$WORKER.DISPATCH_WORK_ITEMS []

      ORA-25153: Temporary Tablespace is Empty

      ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86

      ORA-06512: at "SYS.KUPW$WORKER", line 8159

      ----- PL/SQL Call Stack -----

        object      line  object

        handle    number  name

      0x671cdfbc     19028  package body SYS.KUPW$WORKER

      0x671cdfbc      8191  package body SYS.KUPW$WORKER

      0x671cdfbc      8980  package body SYS.KUPW$WORKER

      0x671cdfbc      1651  package body SYS.KUPW$WORKER

      0x671d0ca4         2  anonymous block

       

      ORA-39126: Worker unexpected fatal error in KUPW$WORKER.DISPATCH_WORK_ITEMS []

      ORA-25153: Temporary Tablespace is Empty

      ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86

      ORA-06512: at "SYS.KUPW$WORKER", line 8159

       

      ----- PL/SQL Call Stack -----

        object      line  object

        handle    number  name

      0x671cdfbc     19028  package body SYS.KUPW$WORKER

      0x671cdfbc      8191  package body SYS.KUPW$WORKER

      0x671cdfbc      8980  package body SYS.KUPW$WORKER

      0x671cdfbc      1651  package body SYS.KUPW$WORKER

      0x671d0ca4         2  anonymous block

       

      Job "DVN"."SYS_EXPORT_FULL_04" stopped due to fatal error at 16:55:16



      $ expdp directory=dpbkp dumpfile=dvnstu.dmp logfile=dvnstu.log tables='dvn.dvnstudent'

      Export: Release 11.2.0.1.0 - Production on Wed Apr 9 17:00:23 2014

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

       

      Username: dvn

      Password:

       

      Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production

      With the Partitioning, OLAP, Data Mining and Real Application Testing options

      ORA-25153: Temporary Tablespace is Empty

      ORA-06512: at "SYS.DBMS_LOB", line 664

      ORA-06512: at "SYS.DBMS_DATAPUMP", line 3901

      ORA-06512: at line 1

       

       

      SQL> Select name from v$tempfile;

       

       

      NAME

      --------------------------------------------------------------------------------

      /u03/oradata/bsnl/mytemp01.dbf