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_at_xs4all.nl> 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
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Sep 26 2005 - 01:25:41 CDT
