Truncate - ORA-00054 resource busy and acquire with NOWAIT specifed
747491Jan 19 2010 — edited Jan 19 2010All,
I'm getting an 'ORA-00054: resource busy and acquire with NOWAIT specified' error, but can't see why.
We are attempting to run four concurrent processes, each of which should truncate and insert into a mutually exclusive sub-partition as follows:
Process A truncates and inserts into subpartition Y2010_Q1_M01_D15_A
Process B truncates and inserts into subpartition Y2010_Q1_M01_D15_B
Process C truncates and inserts into subpartition Y2010_Q1_M01_D15_C
Process D truncates and inserts into subpartition Y2010_Q1_M01_D15_D
This works fine for Process A and Process B, however, when we run Process C or Process D we get the ORA-00054 during the truncate subpartition process - does anyone know why this would happen?
Any help with this would be much appreciated.