oracle如何锁住表 oracle锁表语句

Oracle中什么锁用于锁定表,仅允许其他用户查询表中的行,行不允许插入,更新,或删除行

ORACLE里锁有以下几种模式:

0：none

1：null 空

2：Row-S 行共享(RS)：共享表锁，sub share

3：Row-X 行独占(RX)：用于行的修改，sub exclusive

4：Share 共享锁(S)：阻止其他DML操作，share

5：S/Row-X 共享行独占(SRX)：阻止其他事务操作，share/sub exclusive

6：exclusive 独占(X)：独立访问使用，exclusive

一般是自动实现的，譬如你用DDL语句，那个表肯定就是表锁定了，DML不能使这个表不能插入，只能用手工锁定这个表来实现。lock table table_name in exclusive mode NOWAIT

相关问答

Q1: oracle lock table怎么锁不住表

select 操作不锁表

其实就是 ORACLE 读表操作不会加锁，阻塞写操作

Q2: oracle表在什么情况下会被锁住

在对指定表做append操作，其他再做truncate时候，会产生锁表，如下验证步骤，

1、创建测试表，

create table test_lock(id number, value varchar2(200));

2、执行append语句；并且不做提交，insert /*+append*/ into test_lock values(1,1);

3、再次执行清表语句，truncate table test_lock;报锁表错误，

4、查看锁表语句，发现被锁表，

select b.object_name, t.*

from v$locked_object t, user_objects b

where t.object_id = b.object_id

Q3: oracle 锁表的语句

锁表：LOCK TABLE tablename IN 锁模式 MODE;

解锁：commit或rollback;

锁模式有以下几种：

ROW SHARE

ROW SHARE permits concurrent access to the locked table but prohibits users from locking the entire table for exclusive access. ROW SHARE is synonymous with SHARE UPDATE, which is included for compatibility with earlier versions of Oracle Database.

ROW EXCLUSIVE

ROW EXCLUSIVE is the same as ROW SHARE, but it also prohibits locking in SHARE mode. ROW EXCLUSIVE locks are automatically obtained when updating, inserting, or deleting.

SHARE UPDATE

See ROW SHARE.

SHARE

SHARE permits concurrent queries but prohibits updates to the locked table.

SHARE ROW EXCLUSIVE

SHARE ROW EXCLUSIVE is used to look at a whole table and to allow others to look at rows in the table but to prohibit others from locking the table in SHARE mode or from updating rows.

EXCLUSIVE

EXCLUSIVE permits queries on the locked table but prohibits any other activity on it.

Q4: 怎样在oracle 给表加锁？？

lock table 表名 exclusive mode nowait; -- 锁整个表

select * from 表名 where XXX for update nowaitl -- 锁符合条件oracle如何锁住表的记录

关于oracle如何锁住表和oracle锁表语句的介绍到此就结束了，不知道你从中找到你需要的信息了吗 ？如果你还想了解更多这方面的信息，记得收藏关注本站。