Hi all ,
I have 2 TEMPORARY tablespaces which I want to drop and recreate with better
storage options. My worries:
1)If I connect as sysdba, what TEMP talespace will sysdba's session be using
given that a select from dba_users shows SYS SYSTEM users having TEMP as
their TEMPORARY tablespace.
Simon,
You only use the TEMP tablespace when performing a GROUP BY or a sort.
In your case, this will not be happening to the SYS account during the drop
and recreate of the tablespace.
PS - change your drop tablespace command to:
SQLDROP tablespace TEMP
3and DATAFILES;
There are no