I am having trouble deleting records in a table by ID before I load data to the same table using Oracle Enterprise Stage.
I am using the Load / Append mode in the properties with the Open Command as
DELETE FROM TABLE WHERE ID='#ID#'.
I get these fatal warnings
and at times a fatal warningORA-00054: resource busy and acquire with NOWAIT specified
The call to sqlldr failed; the return code = 256;
please see the loader logfile: /usr/local/dstage/Ascential/DataStage/Scratch/ora.13138.557705.1.log for details.
Is there a way to accomplish the delete part of the table before loading the table requirement using the Open Command.that no rows were returned. And it also seems to be running the Delete statement on all the nodes.
Thanks.