只读表空间的一个测试
SQL> create table t1
2 (a varchar2(10),
3 b varchar2(20))
4 tablespace ts;
Table created.
SQL> insert into t1
2 values(1,'a');
1 row created.
SQL> insert into t1
2 values(2,'b');
1 row created.
SQL> commit;
Commit complete.
SQL> alter tablespace ts read only;
Tablespace altered.
SQL> alter table t1 add (c varchar2(20));
Table altered.
SQL> select *
2 from t1;
A B C
---------- -------------------- --------------------
1 a
2 b
SQL> alter tablespace ts read write;
Tablespace altered.
SQL>
2 (a varchar2(10),
3 b varchar2(20))
4 tablespace ts;
Table created.
SQL> insert into t1
2 values(1,'a');
1 row created.
SQL> insert into t1
2 values(2,'b');
1 row created.
SQL> commit;
Commit complete.
SQL> alter tablespace ts read only;
Tablespace altered.
SQL> alter table t1 add (c varchar2(20));
Table altered.
SQL> select *
2 from t1;
A B C
---------- -------------------- --------------------
1 a
2 b
SQL> alter tablespace ts read write;
Tablespace altered.
SQL>
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/26870952/viewspace-2149457/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
创建非默认块大小表空间
请登录后发表评论
登录
全部评论
