6 Replies Latest reply: Feb 6, 2013 3:07 AM by Osama_Mustafa RSS

    Ora-01555

    969526
      Hi exports,

      I am getting the following error in my database....


      ORA-31693: Table data object "ORISSA_TRANSACTION"."SELLER_BIOMETRICS_TBL" failed to load/unload and is being skipped due to error:
      ORA-02354: error in exporting/importing data
      ORA-01555: snapshot too old: rollback segment number 140 with name "_SYSSMU140$" too small
      *** 2013-02-06 02:58:14.090
      ORA-31693: Table data object "ORISSA_TRANSACTION"."BUYER_BIOMETRICS_TBL" failed to load/unload and is being skipped due to error:
      ORA-02354: error in exporting/importing data
      ORA-01555: snapshot too old: rollback segment number 232 with name "_SYSSMU232$" too small


      The following is my Undo parameter setting....


      SQL> set lines 180 pages 400
      SQL> show parameter undo

      NAME TYPE VALUE
      ------------------------------------ ----------- ------------------------------
      undo_management string AUTO
      undo_retention integer 5400
      undo_tablespace string UNDOTBS1
      SQL>

      Can i increase  undo_retention Parameter...

      Please suggest the solution....


      Regards
      Asit
        • 1. Re: Ora-01555
          sb92075
          Asit Kumar Mohanty wrote:
          Hi exports,

          I am getting the following error in my database....


          ORA-31693: Table data object "ORISSA_TRANSACTION"."SELLER_BIOMETRICS_TBL" failed to load/unload and is being skipped due to error:
          ORA-02354: error in exporting/importing data
          ORA-01555: snapshot too old: rollback segment number 140 with name "_SYSSMU140$" too small
          *** 2013-02-06 02:58:14.090
          ORA-31693: Table data object "ORISSA_TRANSACTION"."BUYER_BIOMETRICS_TBL" failed to load/unload and is being skipped due to error:
          ORA-02354: error in exporting/importing data
          ORA-01555: snapshot too old: rollback segment number 232 with name "_SYSSMU232$" too small


          The following is my Undo parameter setting....


          SQL> set lines 180 pages 400
          SQL> show parameter undo

          NAME TYPE VALUE
          ------------------------------------ ----------- ------------------------------
          undo_management string AUTO
          undo_retention integer 5400
          undo_tablespace string UNDOTBS1
          SQL>

          Can i increase  undo_retention Parameter...

          Please suggest the solution....


          Regards
          Asit
          increase size of UNDO tablespace
          • 2. Re: Ora-01555
            969526
            The following is the size of my undo tablespace....


            Tablespace Size (MB) Free (MB) % Free % Used
            -----------------------------------------------------------------------------------------------------
            UNDOTBS1 11225 9614.375 86 14
            • 3. Re: Ora-01555
              sb92075
              Asit Kumar Mohanty wrote:
              The following is the size of my undo tablespace....

              Tablespace Size (MB) Free (MB) % Free % Used
              -----------------------------------------------------------------------------------------------------
              UNDOTBS1 11225 9614.375 86 14
              now after the BIG load has aborted

              Handle:     Asit Kumar Mohanty
              Status Level:     Newbie
              Registered:     Oct 19, 2012
              Total Posts:     40
              Total Questions:     14 (4 unresolved)

              do nothing & enjoy your errors!
              • 4. Re: Ora-01555
                969526
                sb92075 wrote:
                Asit Kumar Mohanty wrote:
                The following is the size of my undo tablespace....

                Tablespace Size (MB) Free (MB) % Free % Used
                -----------------------------------------------------------------------------------------------------
                UNDOTBS1 11225 9614.375 86 14
                now after the BIG load has aborted

                Handle:     Asit Kumar Mohanty
                Status Level:     Newbie
                Registered:     Oct 19, 2012
                Total Posts:     40
                Total Questions:     14 (4 unresolved)

                do nothing & enjoy your errors!
                Means...????
                • 5. Re: Ora-01555
                  sb92075
                  Asit Kumar Mohanty wrote:
                  sb92075 wrote:
                  Asit Kumar Mohanty wrote:
                  The following is the size of my undo tablespace....

                  Tablespace Size (MB) Free (MB) % Free % Used
                  -----------------------------------------------------------------------------------------------------
                  UNDOTBS1 11225 9614.375 86 14
                  now after the BIG load has aborted

                  Handle:     Asit Kumar Mohanty
                  Status Level:     Newbie
                  Registered:     Oct 19, 2012
                  Total Posts:     40
                  Total Questions:     14 (4 unresolved)

                  do nothing & enjoy your errors!
                  Means...????
                  you have more than one challenge completing import

                  WHY?

                  how did DB get created?
                  • 6. Re: Ora-01555
                    Osama_Mustafa
                    Check MOS notes :
                    ORA 01555 "snapshot too old: rollback segment number %s with name \"%s\" too small" [ID 1555.1]
                    Master Note for ORA-1555 Errors [ID 1307334.1]