ORA-00054 when trying to run commands as batch
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: ORA-00054 when trying to run commands as batch

Threaded View

  1. #1
    Join Date
    May 2001
    Posts
    285

    Unhappy ORA-00054 when trying to run commands as batch

    Hi list,

    I got no error when trying to run 4 oracle statement manually one after another. But when I tried to put all statements in a .sql file and run that file, I got error message

    ORA-00054: resource busy and acquire with NOWAIT specified

    But there is no other activity on this test server plus I didn't have NOWAIT specified.

    Here are the statements I put in a .sql file:

    drop index REC_DAT_SEARCH;

    create index REC_DAT_SEARCH on I3_RECORDINGDATA (ENTRYTYPE, COMPRESSINGMACHINE, RECORDINGDATE);

    UPDATE I3_RECORDINGDATA SET CALLDIRECTION = 'Inbound'
    wHERE CALLDIRECTION = 'I' AND ENTRYTYPE NOT IN (2, 3);

    UPDATE I3_RECORDINGDATA SET CALLDIRECTION = 'Outbound'
    WHERE CALLDIRECTION = 'O' AND ENTRYTYPE NOT IN (2, 3);


    Thanks for your input!
    Last edited by elaine3839; 06-30-2003 at 05:31 PM.

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