From oracle-l-bounce@freelists.org Mon Sep 26 01:17:11 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j8Q6HBav017669 for ; Mon, 26 Sep 2005 01:17:11 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j8Q6H46H017630 for ; Mon, 26 Sep 2005 01:17:04 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id EB23F1EE951; Mon, 26 Sep 2005 01:17:01 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 21335-08; Mon, 26 Sep 2005 01:17:01 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3E42B1EED97; Mon, 26 Sep 2005 01:17:01 -0500 (EST) Subject: Re: Permanent TS for sorting From: Carel-Jan Engel To: oracle.tutorials@gmail.com Cc: "Kennedy, Jim" , oracle-l@freelists.org In-Reply-To: <75aa80160509252232ec5f62b@mail.gmail.com> References: <75aa80160509252232ec5f62b@mail.gmail.com> Content-Type: multipart/alternative; boundary="=-v+C6YruflkhV3EVnAkHf" Organization: DBA!ert Date: Mon, 26 Sep 2005 08:14:44 +0200 Message-Id: <1127715284.1051.7.camel@dbalert199.dbalert.nl> Mime-Version: 1.0 X-archive-position: 25873 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: cjpengel.dbalert@xs4all.nl Precedence: normal Reply-To: cjpengel.dbalert@xs4all.nl X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-3.5 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE autolearn=ham version=2.63 --=-v+C6YruflkhV3EVnAkHf Content-Type: text/plain Content-Transfer-Encoding: 7bit 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? > > --=-v+C6YruflkhV3EVnAkHf Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 7bit 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?

--=-v+C6YruflkhV3EVnAkHf-- -- http://www.freelists.org/webpage/oracle-l