I have a cronjob that exports data from the DB and then truncates the tables. This job has worked fine for the past 6 months, but now I am getting the following errors. The export works good, and then BOOM. What exactly is a "nowait" and how can I fix it?
thanks,
Magnus


truncate table ACTIONS;
truncate table APP_TICKER;
truncate table CUST_DATA;
truncate table INVESTMENT_PLANNER;
truncate table ACTIONS
*
ERROR at line 1:
ORA-00054: resource busy and acquire with NOWAIT specified


truncate table CUST_DATA
*
ERROR at line 1:
ORA-00054: resource busy and acquire with NOWAIT specified

shamrock% oerr ORA 00054
00054, 00000, "resource busy and acquire with NOWAIT specified"
// *Cause: Resource interested is busy
// *Action: Retry if necessary