4 Replies Latest reply on Jun 20, 2013 1:14 PM by 985871

    ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

    985871

      Hi All ,

       

      I am using oracle 11.2.0.3 with 3 node rac with ODI .

       

      I have the below table which i am not able to drop  and giving the error .

       

      SQL> drop table I$_CDS_FAULT_DEV1;

      drop table I$_CDS_FAULT_DEV1

                 *

      ERROR at line 1:

      ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

       

       

      SQL> show parameter ddl_lock

       

       

      NAME                                 TYPE        VALUE

      ------------------------------------ ----------- ------------------------------

      ddl_lock_timeout                     integer     300

       

      i changed to 100 but still the same error also i have checked and there are no locks . Can you please provide me a way to resolve this issue .

       

      Regards ,

      DBApps