欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  IT编程

[20190524]DISABLE TABLE LOCK(12c).txt

程序员文章站 2022-07-09 21:33:44
[20190524]DISABLE TABLE LOCK(12c).txt--//如果禁止table lock时,一些ddl操作会被禁止.但是我有点吃惊的是增加字段不受限制.--//链接:http://blog.itpub.net/267265/viewspace-2645161/=>[201905 ......

[20190524]disable table lock(12c).txt

--//如果禁止table lock时,一些ddl操作会被禁止.但是我有点吃惊的是增加字段不受限制.
--//链接:http://blog.itpub.net/267265/viewspace-2645161/=>[20190522]disable table lock.txt
--//昨天kerrycode给我反馈,10g和11g某个版本增加1列会遇到ora-00069错误.

1.环境:
scott@test01p> @ ver1
port_string                    version        banner                                                                               con_id
------------------------------ -------------- -------------------------------------------------------------------------------- ----------
ibmpc/win_nt64-9.1.0           12.2.0.1.0     oracle database 12c enterprise edition release 12.2.0.1.0 - 64bit production              0

scott@test01p> create table t as select rownum id from dual ;
table created.

scott@test01p> alter table t disable table lock;
table altered.

2.测试:
scott@test01p> truncate table t;
truncate table t
               *
error at line 1:
ora-00069: cannot acquire lock -- table locks disabled for t

scott@test01p> alter table t add v1 varchar2(10);
alter table t add v1 varchar2(10)
*
error at line 1:
ora-00069: cannot acquire lock -- table locks disabled for t

--//很明显11.2.0.4下存在问题,估计遇到了bug,我自己都无法理解在11.2.0.4下的测试结果.