Re: Index and order by on Oracle 7.1
From: Dave Mausner <dmausner_at_brauntech.com>
Date: 1996/10/05
Message-ID: <534lc3$19k_002_at_dmausner.brauntech.com>#1/1
Date: 1996/10/05
Message-ID: <534lc3$19k_002_at_dmausner.brauntech.com>#1/1
In article <5345r1$7fh_at_news.cis.okstate.edu>, wshiang_at_a.cs.okstate.edu (WANG SHIANG HUEY) wrote:
>I got message ORA-001652 unable to extend temp segment by ###
>in tablespace SYSTEM
your users are creating temporary segments in the system tablespace. this can halt your database. if you already have a TEMP tablespace (or something like it) then "alter user so-and-so temporary tablespace TEMP".
if not, either add another file to the system tablespace or (preferably) create a TEMP tablespace with enough disk space for sorting your index, then alter users as above. Received on Sat Oct 05 1996 - 00:00:00 CEST