Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: RO tablespaces, LMT and drop table.

Re: RO tablespaces, LMT and drop table.

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Sun, 23 Mar 2003 07:52:25 +1100
Message-ID: <ST3fa.5625$dE2.13576@newsfeeds.bigpond.com>

"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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US