Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: RO tablespaces, LMT and drop table.
"Tanel Poder" <tanel@@peldik.com> wrote in message
news:3e7c9d66$1_2_at_news.estpak.ee...
> Hi!
>
> When dropping a table from a read only LMT tablespace, dictionary is
> updated, but the extent bitmap in datafile isn't, for obvious reasons.
Now,
> if I put my tablespace back to read write, how do I get the extent,
> originally belonging to dropped table, freed?
Just wait and SMON should eventually get round to it.
From memory, I think I've done an alter tablespace blah coalesce just to get the thing happening sooner (though LMTs don't need coalescing, of course).
And a shutdown and startup will most definitely cause the thing to be cleared, too (but is a tad drastic!!).
Regards
HJR
Received on Sat Mar 22 2003 - 14:52:25 CST