Re: RO tablespaces, LMT and drop table.

Hi again,

I probably didn't wait enough for SMON to start and clean up the TEMP segments (left by drop table on read only TS). alter session set events 'immediate trace name DROP_SEGMENTS level 16' did the job.

Tanel.

> 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?
>
> I've tried just creating additional table in "full" tablespace or
extending
> the datafile to create a second table and allocating extent over datafile
> boundary (to invoke smon as was done with temp segments), I tried even
> coalesce command on LMT (sic) tablespace etc, but so far I haven't got my
> extent back. I have tested this on Linux and Solaris.
Received on Sat Mar 22 2003 - 11:41:41 CST