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

In order to prevent the unlimited increase of temporary tablespaces, I use the method of rebuilding temporary tablespaces at regular intervals. For convenience, I keep two sets of statements and execute them in turn.

Assuming that the temporary tablespace name is temp, create a new tempa tablespace and delete the temp tablespace as follows:

Alter tablespace temp shrink spacekeep 400M

Create temporary tablespace TEMPA

TEMPFILE'/ opt/app/oracle/oradata/orcl/tempa01.dbf'

SIZE 8192M REUSE AUTOEXTEND ON NEXT 1024K MAXSIZE UNLIMITED

Alter database default temporary tablespace tempa;-change the default temporary tablespace

Drop tablespace temp including contents and datafiles;-deletes the original temporary tablespace

Example

Create temporary tablespace TEMP TEMPFILE'/ u01/app/oracle/oradata/orcl/temp01.dbf'

SIZE 256M REUSE AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED

Alter database default temporary tablespace TEMP

Drop tablespace TEMP_NEW including contents and datafiles

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.