Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: RO tablespaces, LMT and drop table.
So what is this trace supposed to do?
-- Terry Dykstra Canadian Forest Oil Ltd. "Tanel Poder" <tanel@@peldik.com> wrote in message news:3e7c9f97$1_2_at_news.estpak.ee...Received on Mon Mar 24 2003 - 10:00:50 CST
> 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.
>
>