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..

Report message to a moderator

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: 68666
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jul 05 12:25:27 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.