»

转移 Oracle 的TEMP表空间

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.

Tags: ,

This entry was posted on 星期一, 十一月 24th, 2008 at 下午 1:38 and is filed under Oracle. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply