Re: Unable to extend temp segment...

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

1. Create large indexes neet large temp-segments
2. Dont'use SYSTEM-Ts for TEMP-Segments Use a large enough separate tablespace (and set it to TEMPORARY (avilable since ORA7.3))

-- 
=====================================
Norbert Ferstl
DI Forsthuber GmbH
Kohlbauernstr. 17
A-2630 Ternitz, AUSTRIA
Tel: +43 2630 382500
Fax: +43 2630 3825014
<ferstl_at_netway.at>
=====================================