Home » RDBMS Server » Server Utilities » Datapump Import ORA-01555 (12.1.0.2.0,Linux x86_64)
Datapump Import ORA-01555 [message #638952] Fri, 26 June 2015 08:35 Go to next message
preet_kumar
Messages: 204
Registered: March 2007
Senior Member

I am using impdp using network link with par file with option flashback_time=SYSTIMESTAMP.
Also i increased the undo_retention to 25000 on source but still i receive below error importing a huge table.

ORA-01555: Snapshot too old: Rollback-Segmentnumber 11 name "_SYSSMU11_112490461$" is too small

Do i also have to increase undo_retention on the target DB on which i am running impdp ?
Re: Datapump Import ORA-01555 [message #638953 is a reply to message #638952] Fri, 26 June 2015 08:42 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Do i also have to increase undo_retention on the target DB on which i am running impdp ?
yes
Previous Topic: SQL Loader WHEN clause with NULL Values
Next Topic: Expdb with parallel parameter writes files one at a time
Goto Forum:
  


Current Time: Thu Mar 28 05:33:01 CDT 2024