You are here: Home // Oracle 11g // 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

Posted by Oracle 11g Release 2 on Aug 25, 2005 | Leave a Comment

Cause: User attempted to create index online without allowing DML Share lock See the solution below.

Error solution: allow DML share lock on the base table

Database version: Oracle 11g Release 2 (11.2)

Tags: ,

Leave a Reply

Copyright © 2009 Oracle Error Codes Database. All rights reserved.
Powered by WordPress.
Promotes: Zobacz ten serwis stoiska targowe randki wyposażenie łazienek dom weselny warszawa