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 -> Deallocating sort segment in Oracle 9i2 ?

Deallocating sort segment in Oracle 9i2 ?

From: Jarek <jpalka_at_interia.KILLSPAM.pl>
Date: Tue, 29 Oct 2002 15:23:25 +0100
Message-ID: <apm5l5$qmt$1@news.telbank.pl>


I need to shrink tempfile size without restarting database. I've temporary tablespace and during large sort operation it grew up to 1GB. V$SORT_USAGE returns no rows,
V$SORT_SEGMENT returns one sort segment with summary size about 1GB.

When I invoke (as described on metalink Note:132913.1)

SQL> ALTER tablespace TEMP default storage (pctincrease 0) I receive ORA-03217:invalid option for alter of TEMPORARY TABLESPACE

How can I deallocate this unused,unnecessary sort segment ???

-- 
____________________________________________________________
Jaroslaw Palka    <jpalka_at_interia.KILLSPAM.pl>
Katowice POLAND   <Remove KILLSPAM from address >
Received on Tue Oct 29 2002 - 08:23:25 CST

Original text of this message

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