Re: RO tablespaces, LMT and drop table.

From: Tanel Poder <tanel_at_@peldik.com>
Date: Sun, 23 Mar 2003 10:43:11 +0200
Message-ID: <3e7d72e2$1_1@news.estpak.ee>

9.2.0.1 on Solaris.

I did try both coalesce and offline/online as well, didn't help, only waiting several minutes or setting immediate event DROP_SEGMENTS did.

Can't test it on 8i right now..

Tanel.

"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:H%7fa.5748$dE2.13593_at_newsfeeds.bigpond.com...
> Interesting. I first encountered this in 8.1.6, and I could have sworn a
> coalesce did the trick.
>
> What version are you using??
>
> Also: I should have remembered, an offline tablespace followed pretty
> sharpish by an online tablespace did the trick for me, too. (Again a tad
> drastic).
>
> Regards
> HJR
>
>
Received on Sun Mar 23 2003 - 02:43:11 CST