| LMT tablespace [message #445191] |
Fri, 26 February 2010 06:12  |
TRaj
Messages: 82
Registered: September 2006
|
Member |
|
|
Hi,
Need explanation for the below one ....
For a locally managed tabelspace, the dropped segment is changed to a Temp. Segment, to prevent bitmap from being updated.
Thanks.
|
|
|
|
| Re: LMT tablespace [message #445197 is a reply to message #445191] |
Fri, 26 February 2010 07:01  |
 |
Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Always post the reference (preferably a link) where you read this.
To drop a segment in LMT, Oracle has to make several things among them update several tables of the dictionary and update bitmap in the datafiles that indicate which blocks are used and which ones are free.
It cannot do all of this at the same time, so it starts to invalidate the usage of the segment converting its type to temporary segment, then it has time to do the rest of the job as no one else can access this segment.
Regards
Michel
[Updated on: Mon, 01 March 2010 02:34] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
