Re: Unable to extend temp segment...

You didn't indicate what OS the DB is running on but in general you shouldn't have index and data tables in the system tablespace - create separate tablespaces for data and indexes ; Also check to see if in your operating system there is a limit on the number of extents that can be allocated to a tablespace, regardless of max size of the tablespace,

Hope it helps,
John Greco
Oracle DBA ( 7.3, Netware 4.11)

jkomula_at_server.seas.ucla.edu (Jarno Komulainen) wrote:

> 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