Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: temp tablespace

Re: temp tablespace

From: Stephan Bressler <stephan.bressler_at_siemens.com>
Date: Mon, 31 Mar 2003 11:48:09 +0200
Message-ID: <b692ps$arf$1@news.mch.sbs.de>


> 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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US