RE: Permanent TS for sorting

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] En nombre de DBA Deepak
Enviado el: Lunes, 26 de Septiembre de 2005 01:24 Para: Carel-Jan Engel; oracle-l_at_freelists.org 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_at_xs4all.nl> 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 



--
http://www.freelists.org/webpage/oracle-l