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/
No comments:
Post a Comment