Row Exclusive Table Lock 行级排它锁
The hang is caused by an exclusive row lock on table EMPLOYEE.
挂起是由表 EMPLOYEE 上一个独占式的行锁导致的。
This means that an exclusive lock is always placed on the indexed table while a functional index is being created or dropped.
这说明，在创建或删除函数索引时，执行索引的表中始终持有一个排他锁。
The load utility accomplishes this by requesting a super exclusive (Z) lock on the table and retaining this lock for the duration of the load operation (see Listing 4).
load 工具实现这一点的方法是，请求目标表上的一个超级排他（Z）锁，并在加载操作期间一直持有这个锁（参阅清单 4）。
应用推荐