Undo_retention value

[sireesha9]

I am doing an import with datapump via network_link.The size of the schemais 480Gb.

Current undo_retention valueis 21600

The size of the undo tablespace is 63Gb


Please suggest undo_retention value to be set during the import to avoid the ora-1555 error.

Thanks..

 

[RobertT687]

Try running this query:

select max(maxquerylen) seconds from v$undostat;

Then set the value of undo_retention to something higher than the returned value.