ora-00054
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: ora-00054

  1. #1
    Join Date
    May 2002
    Posts
    232
    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
    kavitha

  2. #2
    Join Date
    Mar 2002
    Posts
    301
    Hi,

    Check whether any other user is running a transaction.

    Vijay.
    Say No To Plastics

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width