Hi,
Sorting does not require any quotas on TEMP tablespace, as sorting is done by the system on behalf of the (DB) user.
How about dynamic SQL, which generates temporary tables ?
Do users need quota on TEMP tablespace for that - otherwise they won't be able to create and /or fill such tables ?
Thanks in advance,
Tajci :confused: