Re: Permanent TS for sorting

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

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?
> 
> 


Other related posts: