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