Re: Index and order by on Oracle 7.1
Date: 1996/10/10
Message-ID: <01bbb744$01ad14c0$084e78cb_at_Pacific.pacific.com.sg>#1/1
Set the temporary tablespace of the user who is querying to TEMP(or
whatever u like)
Alter the default storage parameters of his temporary tablespace to
something bigger than default
Eg:
SQL>ALTER TABLESPACE TEMP
SQL>DEFAULT STORAGE(INITIAL 10M NEXT 5M PCTINCREASE 0);
WANG SHIANG HUEY <wshiang_at_a.cs.okstate.edu> wrote in article
<5345r1$7fh_at_news.cis.okstate.edu>...
> Hi, Oracle guru:
> I have created an index based on certain key in a table, and
> tried to run query sort by the field I defined in index,
> I got message ORA-001652 unable to extend temp segment by ###
> in tablespace SYSTEM
> after browsing documentatin, I increase sort_area_size to 32000 (16382
> by default), it still didn't solve the problem. Any body know
> what that message is all about? SYSTEM tablespace still has more 50%
> free. Thanks in advance.
>
> --
> Shiang-Huey Wang
> Leather Center, Inc.
> sherry_at_leathercenter.com
> wshiang_at_a.cs.okstate.edu
>
Received on Thu Oct 10 1996 - 00:00:00 CEST