Re: Permanent TS for sorting
- From: DBA Deepak <oracle.tutorials@xxxxxxxxx>
- To: Carel-Jan Engel <cjpengel.dbalert@xxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Mon, 26 Sep 2005 11:53:39 +0530
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:
