Home » RDBMS Server » Server Administration » Undo retention value
Undo retention value [message #358464] Tue, 11 November 2008 08:20 Go to next message
sireesha9
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.

Thanks..
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: 64131
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.

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


Current Time: Wed Dec 07 14:31:59 CST 2016

Total time taken to generate the page: 0.09559 seconds