Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Deallocating sort segment in Oracle 9i2 ?
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