Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Temp Tablespace Full
On Sun, 25 Dec 2005 08:20:30 -0800, Michael42 wrote:
> 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?
>
Is this really a problem? Lots-a misunderstanding about temp tbsp - check http://asktom.oracle.com/pls/ask/f?p=4950:8:5441221212647011140::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:374218170986
-- Hans Forbrich Canada-wide Oracle training and consulting mailto: Fuzzy.GreyBeard_at_gmail.com *** Top posting [replies] guarantees I won't respond. ***Received on Sun Dec 25 2005 - 10:29:15 CST