ORA-01630: altough I have enough space in temp tablespace

Hello

I am getting a
ORA-max # extents (1017) reached in temp segment in tablespace SYSTEM when I run a procedure, that basically looks like

create or replace abc
  ..
begin
  for i in (select x, y, z from a, b, c where .... order by x, y, z) loop

     ..
  end loop;
end;

The procedure's owner is the same user that runs it, and that user has been assigned a temporary tablespace. This tablespace has plenty of space. Still, Oracle chooses to fill a temporary segment in the SYSTEM tablespace, or at least, that's what I understand from the error message.

Is there a way to circumvent this problem as I don't want to grow the System TS?

TIA MK Received on Tue Jul 16 2002 - 10:02:58 CEST