ORA-00054 when trying to run commands as batch

[elaine3839]

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!