DROP TABLESPACE ts_name INCLUDING DATAFILES takes forever
Hello ,
In a production ORA 11.2.04 linux x86-64 red hat 6 I had the TEMP file 13Giga big.
to reduce the TEMP1 File size I did:
SQL> CREATE TEMPORARY TABLESPACE TEMP2 TEMPFILE '/cluster/extpkg9/oradata/ORA1EXT/temp02.dbf' SIZE 2000M REUSE AUTOEXTEND ON NEXT 1M MAXSIZE unlimited EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;
Tablespace created.
SQL> ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP2;
Database altered.
SQL> DROP TABLESPACE temp INCLUDING CONTENTS AND DATAFILES;
after 2 hours I stop the process
How can complete this ? my disk is 86% FULL Is there a workaround to free disk place?
regards
Giorgio