Shulou(Shulou.com)06/01 Report--

Create a new temporary tablespace tmpa

Create temporary tablespace TEMPA TEMPFILE'/ oracle/tmp/tempa01.dbf 'SIZE 8192 M REUSE AUTOEXTEND ON NEXT 1024K MAXSIZE UNLIMITED

two。 Specify the default temporary tablespace as tmpa

Alter database default temporary tablespace tempa

3. Clear the previous tablespace (be careful not to physically delete the file in the tablespace. If it is physically deleted, the file will be displayed as deleted, but no disk space will be freed. Lsof | grep deleted can view it because there are still processes occupying the file)

Drop tablespace temp including contents

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.