Home » RDBMS Server » Server Administration » Undo retention value
Undo retention value [message #358464] Tue, 11 November 2008 08:20 Go to next message
Messages: 1
Registered: November 2008
Location: Hyderabad
Junior Member
I am doing an import with datapump via network_link.The size of the schema is 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.

Re: Undo retention value [message #358475 is a reply to message #358464] Tue, 11 November 2008 08:58 Go to previous message
Michel Cadot
Messages: 63911
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do it during maintenance hours and not online hours that is import when there is no concurrent transactions.

Previous Topic: Why size od sysaux datafile is limited to 16383MB
Next Topic: What priviliges?
Goto Forum:

Current Time: Sat Oct 22 15:36:17 CDT 2016

Total time taken to generate the page: 0.03982 seconds