you may need o increase SGA and TEMP. You are asking the database to do a
sort without sufficient memory
Brad wrote in message ...
>I have a cursor defined thusly:
>
>Cursor ResultCur (nMinTestResultHistoryID Number) Is
> Select *
> From ATT.Per_Test_Rslt_Hist
> Where Num < nMinTestResultHistoryID
> Order By Num Desc;
>
>The where clause is causing me to blow out my temp tablespace even though
>the Num field is indexed. If I take the where clause out the rest of the
>stored proc starts running right away. The table contains 1.6 million
>records.
>
>The index in Num is defined thusly:
>
>CREATE UNIQUE INDEX ATT.PK_PER_TEST_RSLT_HIST
> ON ATT.PER_TEST_RSLT_HIST(NUM ASC)
>PCTFREE 10
>INITRANS 2
>MAXTRANS 255
>TABLESPACE ATT_DATA
>STORAGE(INITIAL 1M
> NEXT 19928K
> MINEXTENTS 2
> MAXEXTENTS 249
> PCTINCREASE 50
> FREELISTS 1
> FREELIST GROUPS 1)
>NOPARALLEL;
Received on Sun Jan 16 2000 - 11:45:30 CST
