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