ora-00054

[kavithared]

Hii I try to Alter the table in oracle9i i get follow error.
SQL> ALTER TABLE DIGI_AD_TBL ADD(CONSTRAINT ADVUSER_FK FOREIGN KEY(USER_ID)
2 REFERENCES DIGI_LOGIN_TBL (USER_ID));
ALTER TABLE DIGI_AD_TBL ADD(CONSTRAINT ADVUSER_FK FOREIGN KEY(USER_ID)
*
ERROR at line 1:
ORA-00054: resource busy and acquire with NOWAIT specified

thanks

[oravijay]

Hi,

Check whether any other user is running a transaction.

Vijay.