You need a temporary tablespace. Users isn't that kind. Just create a new one or use the temp tablespace created at installation. Regards GBA _____ De: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] En nombre de DBA Deepak Enviado el: Lunes, 26 de Septiembre de 2005 01:24 Para: Carel-Jan Engel; oracle-l@xxxxxxxxxxxxx Asunto: Re: Permanent TS for sorting Unable to perform the task... SQL> alter user deepak temporary tablespace users; alter user deepak temporary tablespace users * ERROR at line 1: ORA-10615: Invalid tablespace type for temporary tablespace On 9/26/05, Carel-Jan Engel <cjpengel.dbalert@xxxxxxxxx> wrote: No, You only need to issue 'ALTER USER deepak TEMPORARY TABLESPACE system'; In that way the default temporary tablespace is overruled for the user specified. If you want to do this for all users you can execute somethng like this from SQL*Plus. set hea off set pagesize 0 SELECT 'ALTER USER '||USERNAME||' TEMPORARY TABLESPACE system;' FROM DBA_USERS SPOOL deepak.sql / @deepak.sql That helps you to change all users in an efficient way. Best regards, Carel-Jan Engel === If you think education is expensive, try ignorance. (Derek Bok) === On Mon, 2005-09-26 at 11:02 +0530, DBA Deepak wrote: Will it not use the default temp TS of the Database? -- Regards, Deepak Oracle DBA