| What is actually undo_retention [message #267981] |
Mon, 17 September 2007 01:15  |
sureshkay
Messages: 21
Registered: June 2007
|
Junior Member |
|
|
Does the undo_retention means the life time of the uncommited data OR Commited Data
which one of the below statement corretly defines the Definition of undo_Retention:
1. If I commit the Transaction the undo segment will remain active till the undo_retention time is over and then it overwrites the segment
2. If there are uncommited Transactions then undo_retention defines the life time for the undo segment and when the time expires the undo segment expires.
One more question:
from Oracle Documentation:
However, since DROP TABLESPACE drops an undo tablespace even if it contains unexpired undo information (within retention period), you must be careful not to drop an undo tablespace if undo information is needed by some existing queries.
How is it possible to drop undo tablespace when the there are unexpired undo information ???
can any one explain with a example.
[Updated on: Mon, 17 September 2007 01:28] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
