1、只读
SQL> alter tablespace lianxi read only;
Tablespace altered
SQL> select TABLESPACE_NAME,STATUS from dba_tablespaces where tablespace_name like 'LIAN%';
TABLESPACE_NAME STATUS
------------------------------ ---------
LIANXI READ ONLY
LIANXI_UNDO ONLINE
LIANXI_TEMP ONLINE
LIANXI_INDEX ONLINE
2、读写
SQL> alter tablespace lianxi read write;
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
SQL>