1、改為隻讀狀态
表空間處于read only 狀态，不可以做dml 操作，但可以删除對象。
09:20:53 SQL> create table t01 (id int) tablespace cuug;
Table created.
09:25:46 SQL> alter tablespace cuug read only;
Tablespace altered.
09:25:53 SQL> insert into t01 values (1);
insert into t01 values (1)
*
ERROR at line 1:
ORA-00372: file 9 cannot be modified at this time
ORA-01110: data file 9: '/u01/app/oracle/oradata/lx02/cuug01.dbf'
09:26:03 SQL> drop table t01 purge;
Table dropped.
2、改為讀寫狀态
09:26:09 SQL> alter tablespace cuug read write;
3、表空間脫機
09:02:25 SQL> select tablespace_name ,status from dba_tablespaces;
TABLESPACE_NAME STATUS
------------------------------ ---------
SYSTEM ONLINE
UNDOTBS1 ONLINE
SYSAUX ONLINE
TEMP ONLINE
USERS ONLINE
EXAMPLE ONLINE
USERS01 ONLINE
USERS02 ONLINE
BIG_TBS ONLINE
UNDOTBS02 ONLINE
TEMP01 ONLINE
TEMP02 ONLINE
TEMP03 ONLINE
TBS_16K ONLINE
14 rows selected.
09:04:26 SQL> alter tablespace tbs_16k offline;
09:04:28 SQL> select tablespace_name ,status from dba_tablespaces;
TBS_16K OFFLINE
注意：System、sysaux、預設臨時表空間、正在使用的undo不能脫機。
4、表空間聯機
09:04:30 SQL> alter tablespace tbs_16k online;
09:08:25 SQL> select tablespace_name ,status from dba_tablespaces;
CUUG
更多oracle視訊教程請點選：http://crm2.qq.com/page/portalpage/wpa.php?uin=800060152&f=1&ty=1&aty=0&a=&from=6