IMP with commit=n ends with IMP-00003 ORA-30036 [message #420915] |
Thu, 03 September 2009 05:23 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
psoftneto
Messages: 44 Registered: July 2008
|
Member |
|
|
Hi all,
We are using Automatic Undo Management. I would like to import a table of 20G.
Will I need 20G for undo tablespace or also 20G for rollback segment ?
If I need 20G for rollback segment - how can I do it with automatic undo management ?
Thanks.
|
|
|
Re: IMP with commit=n ends with IMP-00003 ORA-30036 [message #420931 is a reply to message #420915] |
Thu, 03 September 2009 06:04 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68665 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Quote: | Will I need 20G for undo tablespace or also 20G for rollback segment ?
|
With commit=n, the answer is yes.
Quote: | If I need 20G for rollback segment - how can I do it with automatic undo management ?
|
Yo have nothing to do (this is the purpose of "automatic"), just be sure you have space enough for your undo tablespace taking into account other activities.
Regards
Michel
|
|
|