ORA-00054 when trying to run commands as batch
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!