Archive for 十一月, 2008

转移 Oracle 的TEMP表空间

星期一, 十一月 24th, 2008
CREATE tablespace TEMP2
datafile '/data1/ora9data/temp2_01.dbf' 
size 100k TEMPORARY;

Tablespace created.

ALTER DATABASE DEFAULT TEMPORARY tablespace TEMP2;

Database altered.

DROP tablespace temp including contents AND datafiles;

Tablespace dropped.