We got an Oracle error 1652.
The user made a query without linking the tables and with an order by statement.
The number of records is 25000 * 30000 = 750,000,000 records !

Is it possible to limit the amount of temporary space for an user or is there an other way to do this ?

Kind regards.

PS: we started in oracle level 2 and the response time are much better than informix level 1.

Hi Richard,

For normal (permanent) tablespaces you can do:
alter <user> quota <x> on <tablespace>
However as far as I know this does not work on temporary tablespaces because the temporary segments are always created under the SYS schema (which has no quota of course).

You could check your storage parameters and that might help some:
INITIAL/NEXT: big values and INITIAL=NEXT
PCTINCREASE: