脱机
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
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