Temporary Tablespace Shrink

Large sorting operations can cause temporary tablespace to grow large.  To release disk space, you can shrink temporary tablespace.  The KEEP clause defines the lower bound that the tablespace/tempfile can be shrunk to.


SQL> CREATE temporary tablespace TEMP1 tempfile '+DG_TRX_DD501' SIZE 500m REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
  2  EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1m;

Tablespace created.

SQL> alter tablespace TEMP1 shrink space KEEP 100m;

Tablespace altered.

No comments:

Post a Comment