ORA-00054: resource busy error

[ms_reddy]

Hi friends,

when tried to analyze an index, it is giving me the following error. why?

SQL> analyze index idx_fdx_key validate structure;

analyze index idx_fdx_key validate structure
*
ERROR at line 1:
ORA-00054: resource busy and acquire with NOWAIT specified

thanks

ms reddy

[bensr]

Seems that another program/ statement is using the index by mutating the table or something.
Just wait until its finished

[kong]

When you analyze the index, exclusive locks will be acquired on the index and the underlying table. If another user/package is currently modifying that table and has not committed, you will get the ORA-54 error.

Determine who is accessing which table by joining the V$LOCKED_OBJECT.object_id = DBA_OBJECTS.object_id

Have fun!

Go the Wallabies!