表空间-只读、读写设置

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>