Maybe you should increase the size of the Temp tablespace.
--
javatek?@usa.com
remove the ? to reply.
"cpchan" <cpchaney_at_netvigator.com> wrote in message
news:b95qfb$b8s15_at_imsp212.netvigator.com...
> I don't understand why my Temporary tablespace is always 99% full even we
> shut down the database for a UNIX tar backup on every 6:00 am.
> Do I need to turn off the whole UNIX machine and then turn its power again
> so that all the content of the Temporary tablespace will be cleared ?
> If no, how can I clear all the content of a Temporary tablespace on an
> Oracle 8i RDBMS ?
>
>
>
>
Received on Fri May 09 2003 - 21:22:06 CDT
