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

来源:这里教程网 时间:2026-03-03 13:47:05 作者:

[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下的测试结果.

相关推荐