enable UNDO feature [message #420336] |
Fri, 28 August 2009 07:24 |
g_suri24
Messages: 13 Registered: January 2007 Location: hyderabad
|
Junior Member |
|
|
If u want to create your database with the Automatic Undo Management feature enabled which 2 tasks u perform to acheive this ?
a)set UNDO_RETENTION to AUTO
b)create an initial undo segment in undo tablespace
c)set UNDO_RETENTION TO 900 or more
d)set the parameter UNDO_MANAGEMENT to AUTO
e)set the UNDO_MANAGEMENT parameter to name of an undo tablespace
Answers :C,E
But i think C,D is the answer.what do u say ?
plese reply .....
|
|
|
|
Re: enable UNDO feature [message #420347 is a reply to message #420346] |
Fri, 28 August 2009 08:30 |
g_suri24
Messages: 13 Registered: January 2007 Location: hyderabad
|
Junior Member |
|
|
Hi,
UNDO_MANAGEMENT can be either AUTO/MANUAL but can't be the name of a undo_tablespace.
That's the region i say C,D as answers.
Please post the correct answers.
|
|
|
|
|
|