RE: Permanent TS for sorting
- From: "GBA-DBA" <gba.oraclel@xxxxxxxxx>
- To: <oracle.tutorials@xxxxxxxxx>, "'Carel-Jan Engel'" <cjpengel.dbalert@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 26 Sep 2005 08:59:56 -0500
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] En
nombre de DBA Deepak
Enviado el: Lunes, 26 de Septiembre de 2005 01:24
Para: Carel-Jan Engel; oracle-l@xxxxxxxxxxxxx
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@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:
