Unable to extend temp segment...

From: Jarno Komulainen <jkomula_at_server.seas.ucla.edu>
Date: 1997/10/16
Message-ID: <625df3$l9u@idefix.eunet.fi>#1/1

                Hi

I wonder why i receive following error when i try to create index.

---

SVRMGR> create index yt_yritys_nimipuhelin on yritys (nimi,puhelin); create index yt_yritys_nimipuhelin on yritys (nimi,puhelin)

                                      *

ORA-01652: unable to extend temp segment by 3596 in tablespace SYSTEM

---

I check system tablespace and durring index creation it increases one of the datafiles about 12 meg, then it prints that error message. Datafile max size is 400 meg and it's used 300 meg, there is 100 meg of free space!

jarno komulainen
jarno.komulainen_at_finhost.fi Received on Thu Oct 16 1997 - 00:00:00 CDT