Oracle Database 11G R2 資料表空間管理

標籤：creat   altered   end   local   including   name   AC   檔案   created   

SQL> alter database datafile '/u01/app/oracle/oradata/king/sysaux01.dbf' resize 2048M;

Database altered.

SQL> alter database datafile '/u01/app/oracle/oradata/king/system01.dbf' resize 2048M;

Database altered.

SQL> alter database tempfile '/u01/app/oracle/oradata/king/temp01.dbf' resize 2048M;

Database altered.

SQL> alter database datafile '/u01/app/oracle/oradata/king/undotbs01.dbf' resize 2048M;

Database altered.

SQL> alter database datafile '/u01/app/oracle/oradata/king/users01.dbf' resize 2048M;

Database altered.

SQL> alter database datafile '/u01/app/oracle/oradata/king/sysaux01.dbf' autoextend off;

Database altered.

SQL> alter database datafile '/u01/app/oracle/oradata/king/system01.dbf' autoextend off;

Database altered.

SQL> alter database tempfile '/u01/app/oracle/oradata/king/temp01.dbf' autoextend off;

Database altered.

SQL> alter database datafile '/u01/app/oracle/oradata/king/undotbs01.dbf' autoextend off;

Database altered.

SQL> alter database datafile '/u01/app/oracle/oradata/king/users01.dbf' autoextend off;

Database altered.

建立資料表空間

SQL> create tablespace tpcc

datafile '/u01/app/oracle/oradata/king/tpcc01.dbf'

size 1024M

extent management local

uniform size 1M;

Tablespace created.

增加資料表空間資料檔案

SQL> alter tablespace tpcc

add datafile '/u01/app/oracle/oradata/king/tpcc02.dbf'

size 1024M;

Tablespace altered.

移動資料表空間資料檔案

SQL> alter tablespace tpcc01 offline;  

Tablespace altered.

SQL> host cp /u01/app/oracle/oradata/king/tpcc02.dbf /u02/app/oracle/oradata/king

SQL> alter tablespace tpcc01

rename datafile '/u01/app/oracle/oradata/king/tpcc02.dbf'

to '/u02/app/oracle/oradata/king/tpcc02.dbf';

Tablespace altered.

SQL> alter tablespace tpcc01 online;

Tablespace altered.

SQL> host rm -rf /u01/app/oracle/oradata/king/tpcc02.dbf

刪除資料表空間

SQL> drop tablespace tpcc01 including contents and datafiles;

Tablespace dropped.

Oracle Database 11G R2 資料表空間管理