Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: temp tablespace
> If you really have an urgent need to clean it up: switch it from
> temporary to permanent using the alter tablespace command and switch
> it back from permanent to temporary.
another trick is
alter tablespace temp default storage (initial _the_same_value_as_before_)
This also drops all sort segments and does less harm than switching to
permanent and back.
Stephan
Received on Mon Mar 31 2003 - 03:48:09 CST