aiaiDBA

加微信获取免费职业规划+学习资料，了解年薪50万的DBA是如何练成的

13718043309

010-86462881

ORA-00062: DML full-table lock cannot be acquired; DML_LOCKS is 0

ORA-00062: DML full-table lock cannot be acquired; DML_LOCKS is 0
Cause: The instance was started with DML_LOCKS = 0, and the statement being executed needs a full-table lock (S, X, or SSX).
Action: Restart the instance with DML_LOCKS not equal to zero, and reexecute the statement.

请先 登录 后评论
默认排序 时间排序

1 个回答

小智
ORA-00062：无法获取DML全表锁; DML_LOCKS为0,
.原因：实例以DML_LOCKS = 0启动，并且正在执行的语句需要全表锁定（S，X或SSX）。,
.操作：使用DML_LOCKS不等于零重新启动实例，然后重新执行语句。,
.
请先 登录 后评论
  • 1 关注
  • 0 收藏，1839 浏览
  • 慧慧 提出于 2018-08-30 16:35

相似问题