Re: Undroppable tablespace

From: MarkF <markRED_at_BLUErubico.com>
Date: Fri, 21 Jun 2002 14:28:40 +0200
Message-ID: <ls66hug327gvkvbg7letqtsmm5b28o7n53@4ax.com>

On Fri, 21 Jun 2002 12:48:35 +0200, "Stephan Bressler" <stephan.bressler_at_siemens.com> scrawled:

>Hi,
>
>one reason might be a _huge_ number of extents in your tbs temp (if
>dictionary managed).

TEMP was dictionary managed. I started another "drop tablespace temp" last night that eventually finished after 2 hours.

Still getting the ORA-09999 logged in the alert log and smon trace files, tho.

Cheers,

--
MarkF
Take out the colours to reply.

Received on Fri Jun 21 2002 - 07:28:40 CDT