Re: Permanent TS for sorting

  • From: Carel-Jan Engel <cjpengel.dbalert@xxxxxxxxx>
  • To: oracle.tutorials@xxxxxxxxx
  • Date: Mon, 26 Sep 2005 08:50:29 +0200

What I showed you was on Oracle 9i

No 10g at hand here, but probably you are using 10g.

It is quite handy when you include OS/Oracle version in questions to
this list.
Apearantly Oracle now takes care of DBA's who want to do the
unwanted......
If you still want to do this, you have to downgrade.

Best regards,

Carel-Jan Engel

===
If you think education is expensive, try ignorance. (Derek Bok)
===
On Mon, 2005-09-26 at 11:53 +0530, DBA Deepak wrote:
> 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 


Other related posts: