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.