Oracle DBA, How To, Error, Cause and Action

ORA-08116: can not acquire dml enough lock(S mode) for online index build

ORA-08116: can not acquire dml enough lock(S mode) for online index build


Cause:


User attempted to create index online without allowing DML Share lock



Action:


allow DML share lock on the base table

No comments:

Post a Comment

Thanks for your comment.

Subscribe to: Post Comments (Atom)