脱机
1、
sql> alter tablespace lianxi offline;
Tablespace altered
2、
sql> select TABLESPACE_NAME,STATUS from dba_tablespaces where tablespace_name like 'LIAN%';
TABLESPACE_NAME STATUS
------------------------------ ---------
LIANXI OFFLINE
LIANXI_INDEX ONLINE
LIANXI_TEMP ONLINE
LIANXI_UNDO ONLINE

联机
sql> alter tablespace lianxi online;
Tablespace altered

sql> select TABLESPACE_NAME,STATUS from dba_tablespaces where tablespace_name like 'LIAN%';
TABLESPACE_NAME STATUS
------------------------------ ---------
LIANXI ONLINE LIANXI_UNDO ONLINE LIANXI_TEMP ONLINE LIANXI_INDEX ONLINE