removing extent-basic question

[richieasir]

hi all
I have created a database in my test box and i tried to delete one particular extent say,
d1 f
d2 f
d3 f
d4 f
d5 v
in the above i tried to delete d2 extent which is a fixed one.but the last extent only got deleted and that too a variable extent.
1)from this i come to know that extents wil be deleted from last one by one,is it true?
2)the last extent must be a variable extent in progress then how it has got deleted(i mentioned only one variable extent)?
3)how can i delete the particular extent say d2 extent in my case?
regards
Richards.

 

[TomBascom]

hi all
I have created a database in my test box and i tried to delete one particular extent say,
d1 f
d2 f
d3 f
d4 f
d5 v
in the above i tried to delete d2 extent which is a fixed one.but the last extent only got deleted and that too a variable extent.
1)from this i come to know that extents wil be deleted from last one by one,is it true?

That is what the documentation says and what your tests show. Sounds true to me.

2)the last extent must be a variable extent in progress

This is not true. It is common practice, best practice even, but it is not required that your last extent be variable.

then how it has got deleted(i mentioned only one variable extent)?
3)how can i delete the particular extent say d2 extent in my case?
regards
Richards.

If the high water mark has never moved into d2 then repeated use of prostrct delete will eventually get to it. There is no way to delete one particular extent. You have to start with the highest numbered extent and work your way towards it.