Monday, 16 September 2019

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-orac...
READ MORE ...