When using DataStage development, you encounter an error:
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's big God:
It is possible that the table index is in unusable state and causes the index to unusable: Duplicate keys on unique constraint column, solution skip_index_maintenance or Rebuild Index
I have been pondering for a long while, I this table does not have the index Ah, how could this problem occur? Do not think too much, the OS restarted, run the job, success without error. Tried again, and the same error occurred. Is tangled in, inadvertently the Delete table statement to turn off the session, the job is normal. The final reason is: I delete the table data and there is no commit, causing the data to be re-inserted when the error. It's too careless to remember the knowledge again.
Popular Science itself:
DML (select,insert,update,delete,call,explain plan,lock table,... ) do not submit automatically
DDL Auto-Commit
DCL Auto-Commit
Sql*plus inside if not submitted, the normal exit Sql*plus will be automatically submitted, if the abnormal exit Sql*plus, do not submit.
Example:
Insert into Src.dw_sjc_q_chel_visit_record_d (appkey,method,time,request,response,provider,isbilling)
Select Appkey,method,time,request,response,provider,isbilling from DW_BIZ_CREDIT_ACCESS_BF
Commit
sql*loader-951 Error