| IMP with commit=n ends with IMP-00003 ORA-30036 [message #420915] |
Thu, 03 September 2009 05:23  |
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  |
 |
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
