Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Deallocating sort segment in Oracle 9i2 ?
I think it would be rather easier to create a new temporary tablespace
altogether, and drop the existing one.
Regards
HJR
"Jarek" <jpalka_at_interia.KILLSPAM.pl> wrote in message
news:apm5l5$qmt$1_at_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 - 13:08:02 CST