Recreate temp tablespace in Oracle

SQL> create temporary tablespace temp1 tempfile '/scratch/u01/app/oracle/oradata/tmp01/temp01.dbf' size 10G;

SQL> alter database default temporary tablespace temp1;

SQL> drop tablespace temp INCLUDING CONTENTS AND DATAFILES;

Tablespace dropped.





https://orahow.com/drop-and-recreate-temp-tablespace-in-oracle/

READ MORE ...