Oracle temp 切換與重建

Oracle temp 切換與重建

CREATE TEMPORARY TABLESPACE TEMP2 TEMPFILE
‘/u2/oradb/oradata/topprod/TEMP02.dbf’ SIZE 100M AUTOEXTEND OFF
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;

alter database default temporary tablespace TEMP2;

DROP TABLESPACE TEMP INCLUDING CONTENTS AND DATAFILES;

CREATE TEMPORARY TABLESPACE TEMP TEMPFILE
‘/u2/oradb/oradata/topprod/TEMP01.dbf’ SIZE 20480M AUTOEXTEND OFF
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;
alter database default temporary tablespace TEMP;

DROP TABLESPACE TEMP2 INCLUDING CONTENTS AND DATAFILES;