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