Re: Index and order by on Oracle 7.1

In article dated 4 Oct 1996 23:15:45 GMT, WANG SHIANG HUEY (wshiang_at_a.cs.okstate.edu) wrote:
> 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

The temp segment used for doing the sort filled up the SYSTEM tablespace. You should create a tablespace ('TEMP' for example) for temp segments. Then assign all users to use this as their temporary tablespace:

    alter user foo temporary tablespace temp;

Ensure that it is large enough to hold the data to be sorted.

--
 _--_|\  John Verhoeven           Unix / Database Administrator Westrail
/      \              johnv_at_DIALix.oz.au / jverhoeven_at_westrail.wa.gov.au
*_.--._/
      v   "Smile! things could be worse... So I did... and they were..."