I needed to move my system temporary tablespace. It was using my OS drive.
I found very helpful advice in these two threads:
1452879
290644
I created a new tablespace with:
create temporary tablespace temp_01
tempfile '/d02/oradata/ORATEST/datafile/temp01.dbf' size 200M extent management local;
Below are the last few lines of what I did to redirect.
SQL> select file_name, tablespace_name from DBA_TEMP_FILES;
FILE_NAME
--------------------------------------------------------------------------------
TABLESPACE_NAME
------------------------------
/oracle/product/10.2.0/db_1/oradata/oratest/temp01.dbf
TEMP
/d02/oradata/ORATEST/datafile/temp01.dbf
TEMP_01
SQL> alter user system temporary tablespace temp_01;
User altered.
SQL> drop tablespace TEMP;
drop tablespace TEMP
*
ERROR at line 1:
ORA-12906: cannot drop default temporary tablespace
SQL> alter database default temporary tablespace temp_01;
Database altered.
SQL> drop tablespace TEMP;
This has been running for maybe 20 minutes. Is this reasonable?
My original ts was 17,825+ M
Thanks,
Gregory
It's going on at least 40 minutes now.
Message was edited by:
Canis Polaris
Message was edited by:
Canis Polaris