5 Replies Latest reply: Apr 30, 2013 3:45 AM by Richard Harrison . RSS

    ORA01555"snapshot too old:rollback segment num %s with name "%s" to small

    Soni
      Hi All

      i have and 11gR1(11.1.0.6) DB source instance in wich i have i a partitioned table of 1TB size.
      I want to IMPDP this table using NETWORK_LINK in a 11gR2(11.2.0.3) destination RAC instance.

      when a try to import a get the following error message

      ORA 01555 "snapshot too old: rollback segment number %s with name \"%s\" too small"

      UNDO_RETENTION=130000
      UNDOTBS1=300GB
      UNDOTBS2=220GB

      i have searche dhte metalink docs but did not find any solution.
      is there any hint or document to follow?

      thanks in advance
      Soni