SQL * loader-951 Error

When using datastage for development, the following error occurs:

SQL * loader-951: Error calling once/load Initialization

ORA-00604: Error occured at recursive SQL Level 1

ORA-00054: Resource busy and acquire with Nowait specified

Move out of Google:

It may be because the index in the table is in the unusable state --> leading to the index unusable: duplicate keys on unique constraint column. Solution: skip_index_maintenance or rebuild Index

I have been pondering for a long time. I have no index on this table. How can this problem happen? I didn't think too much about it. I had to restart the OS and run the job without any error. I tried again and encountered the same error. In tangle, the session of the Delete table statement is accidentally closed, and the job is normal. The final cause is that after I delete the table data, there is no commit, which leads to an error when I re-insert the data. It's too careless to record the knowledge.

 

Popular Science:

DML (select, insert, update, delete, call, explain Plan, lock table,...) is not automatically submitted

DDL automatic submission

DCL automatic submission

If SQL * Plus is not submitted, it is automatically submitted when SQL * Plus is exited normally. If SQL * Plus is exited abnormally, It is not submitted.