Re: Unable: NOT THAT SIMPLE!

It may be not that simple. Oracle often produces MISLEADING messages. For example, if I try to create HASH CLUSTER, parameters HASHKEYS and SIZE effectively specify the space which will be allocated to this cluster during creation. Let's say, database block size is 2K, I specify SIZE 1700, then the number of allocated data blocks will be equal to HASHKEYS. If INITIAL, NEXT, MAXEXTENTS are too low, Oracle will not be able to allocate the required space and it produces this completely misleading message about 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
Received on Mon Oct 20 1997 - 00:00:00 CDT