Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle 12c ORA-00054 while trying to create an index

GytisAug 22 2016 — edited Aug 22 2016

Hi guys,

trying to create an index on oracle 12c: create index data_no.memo_cds on data_no.memo("xxx","blah"); but am getting ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired.

Any ideas how to solve this? Tried looking for locking sessions but there is none locking this table.

This post has been answered by AndrewSayer on Aug 22 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 19 2016

Added on Aug 22 2016

#general-database-discussions

17 comments

19,686 views