1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

ORA-04022 Error

Discussion in 'Server Administration and Options' started by ipsharma, Aug 5, 2010.

  1. ipsharma

    ipsharma Guest

    I am getting this error frequently while rebuilding the index.

    ERROR at line 1:
    ORA-20001: ORA-04022: nowait requested, but had to wait to lock dictionary
    object
    ORA-06512: at "MDWDBA.MDW_PKG", line 917
    ORA-04022: nowait requested, but had to wait to lock dictionary object
    ORA-06512: at line 1

    Can anybody tell me why this error and how to resolve this error?
    Thank you
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,344
    Likes Received:
    347
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    It appears that some other process has locked a dictionary object you need to lock to rebuild an index. You need to find that process and see why it has the dictionary locked.