9 Replies Latest reply on Aug 1, 2013 12:02 PM by Dean Gagne-Oracle

    expdp full=y shows 'fatal error '

    Sathyanarayanan

      Hi all,

             any body, please help, I tried to take a full database export using expdp, with the schema name 'x' and password 'x', it is showing error  as follows,

       

       

      [oracle@oracleoel5 ~]$ expdp x/x directory=dpumpdir dumpfile=ramu.dmp full=y  parallel=5 nologfile=y

       

       

      Export: Release 10.2.0.1.0 - Production on Tuesday, 30 July, 2013 15:40:06

       

       

      Copyright (c) 2003, 2005, Oracle.  All rights reserved.

       

       

      Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

      With the Partitioning, OLAP and Data Mining options

      Starting "X"."SYS_EXPORT_FULL_03":  x/******** directory=dpumpdir dumpfile=ramu.dmp full=y parallel=5 nologfile=y

      Estimate in progress using BLOCKS method...

      Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA

      ORA-39125: Worker unexpected fatal error in KUPW$WORKER.GET_TABLE_DATA_OBJECTS while calling DBMS_LOB.CREATETEMPORARY []

      ORA-25153: Temporary Tablespace is Empty

       

       

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

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

       

       

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

        object      line  object

        handle    number  name

      0x4158a904     14916  package body SYS.KUPW$WORKER

      0x4158a904      6300  package body SYS.KUPW$WORKER

      0x4158a904      9120  package body SYS.KUPW$WORKER

      0x4158a904      1880  package body SYS.KUPW$WORKER

      0x4158a904      6861  package body SYS.KUPW$WORKER

      0x4158a904      1262  package body SYS.KUPW$WORKER

      0x414798c0         2  anonymous block

       

       

      Job "X"."SYS_EXPORT_FULL_03" stopped due to fatal error at 15:40:10

       

       

      Thanks & Regards,

      Rajagopal S.,

        • 1. Re: expdp full=y shows 'fatal error '
          DK2010

          Hi,

           

          Error give you some hint

          >>ORA-25153: Temporary Tablespace is Empty

          Have you checked you have temporary tablespace, may be you recreate  your Db and forget to add temporary datafiles. check it

          • 2. Re: expdp full=y shows 'fatal error '
            Sathyanarayanan

            Hi Sir,

                    I created temp. tablespace also, but the same error is coming again & again, what would be the reason,?

                                                                                                                                                                          Regards,

                                                                                                                                                                          Rajagopal. S

            • 3. Re: expdp full=y shows 'fatal error '
              DK2010

              Hi,

              means there was no temp earlier?

              What is the Error you get after adding temp,can you show the Error Here

              You can use the below Query to check the TEMP property, it should return some row


              SELECT * FROM DATABASE_PROPERTIES where PROPERTY_NAME='DEFAULT_TEMP_TABLESPACE';

               

              also check the  temporary tablespace for the user which you are using for Export or use the command

               

              alter user x temporary teblespace <temp>;

              HTH

              • 4. Re: expdp full=y shows 'fatal error '
                Dean Gagne-Oracle

                After creating the temporary tablespace, did you grant access to it to the user running the Data Pump job?

                 

                Dean

                • 5. Re: expdp full=y shows 'fatal error '
                  Sathyanarayanan

                  Hi all,

                   

                         my issue has been resolved, i recreated the database, then consecutively created the temporary tablespace & one  non-system tablespace and assigned it to an user and the operation expdp uname/uname full=y completed successfully.

                   

                  Many Thanks,

                  Rajagopal S.

                  • 6. Re: expdp full=y shows 'fatal error '
                    DK2010

                    Hi,

                    There is no need to create the Db. You only need to do

                    >>created the temporary tablespace & one  non-system tablespace and assigned it to an user

                    Any way You solved it.


                    • 7. Re: expdp full=y shows 'fatal error '
                      Sathyanarayanan

                      Hi Sir,

                              what is the use of temporary tablespace in this regard when assigning to the newly created user, i couldn't able to understand the error, although, i resolved the error,

                      is it true that temporary tablespace stores sorted data, if PGA becomes full?  actually what happens in datapump ?  whether the same 'fatal error' possible in normal export ?

                      • 8. Re: expdp full=y shows 'fatal error '
                        DK2010

                        Hi

                         

                        One Master Table is created in the schema of the current user running the Pump Dump export or import,and it keeps tracks of detailed information. 

                        and this table required storage which should use the default property of schema like default tablespace and default temporary tablesapce

                         

                        >>whether the same 'fatal error' possible in normal export ?

                        No

                        • 9. Re: expdp full=y shows 'fatal error '
                          Dean Gagne-Oracle

                          From what I remember, any kind of SORTS on the data or metadata that the Data Pump job is exporting/importing will be done in the temporary tablespace. If you are running export and you are downgrading:

                           

                          expdp version=older_version ...

                           

                          Then you will need global temporary table to store the downgraded master table in before it is exported.

                           

                          Dean