Re: Temp Tablespace Full

From: aime badrane <badrane.aime_at_neuf.fr>
Date: Thu, 5 Jan 2006 06:30:32 +0100
Message-ID: <dpid72$qaj$1@apollon.grec.isp.9tel.net>

(bonjour Michael, excuse my english)
Normally, the tablespace temp must be empty, after a select,...however i have the save problem and i did:
alter tablespace temp offline;
alter tablespace temp online;
to clean it;

Aimé

"Michael42" <melliott42_at_yahoo.com> a écrit dans le message de news: 1135527630.056281.102700_at_g49g2000cwa.googlegroups.com...
> Hello,
>
> In Oracle 9i I ran an operation that gathered statistics. It ran for
> several hours and I ended up having to break out of it. The result is
> that my TEMP tablespace is full (OEM shows it as full).
> Other than bouncing the database how can I have the TEMP tablespace
> clean itself up?
>
> Thanks,
>
> Michael42
>
Received on Wed Jan 04 2006 - 23:30:32 CST