Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Permanent TS for sorting

RE: Permanent TS for sorting

From: Kennedy, Jim <jim_kennedy_at_mentor.com>
Date: Mon, 26 Sep 2005 07:24:19 -0700
Message-ID: <EF25DB6D87DD1A469C80A312C63C3B4C0484694D@SVR-ORW-EXC-07.mgc.mentorg.com>

-----Original Message-----
From: Carel-Jan Engel [mailto:cjpengel.dbalert_at_xs4all.nl] Sent: Sun 9/25/2005 11:14 PM
To: oracle.tutorials_at_gmail.com
Cc: Kennedy, Jim; oracle-l_at_freelists.org Subject: Re: Permanent TS for sorting  

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

Carel-Jan is correct. But why do you want to do this? It is less effecient than using the temporary tablespace. You can create a 2nd temp tablespace (as temporary) and have it use that if you are tring to use a different one. With the perm tablespace you are going to generate a lot more redo and extent allocation/deallocation. Jim

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Sep 26 2005 - 09:30:12 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US