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: 65150
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: Add datafile to UNDO, then remove datafile again
Next Topic: What priviliges?
Goto Forum:

Current Time: Mon Aug 21 22:39:37 CDT 2017

Total time taken to generate the page: 0.01958 seconds