HI Experts,
We are getting below error:-. we need to modify the script so that,
If the script has ora error then it should load the same .csv file again and then come out of the script
SQL*Loader: Release 12.1.0.2.0 - Production on Wed May 19 09:35:04 2021
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
Control File: las_agt2.ctl
Data File: /opt/app/t1c32/ora01/t1c32/dba/agt2.csv
Bad File: ag3.bad
Discard File: none specified
(Allow all discards)
Number to load: ALL
Number to skip: 1
Errors allowed: 500
Continuation: none specified
Path used: Direct
Table report.agt_prod_stag, loaded from every logical record.
Insert option in effect for this table: TRUNCATE TRAILING NULLCOLS option in effect
Column Name Position Len Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
ID FIRST * , O(") CHARACTER
EVENTID NEXT 4000 , O(") CHARACTER
EVENTNAME NEXT 4000 , O(") CHARACTER
TIMESTAMP NEXT * , O(") DATETIME YYYY-MM-DD"T"HH24:MI:SS.ff3"Z"
EVENTMETHOD NEXT 4000 , O(") CHARACTER
RESOURCENAME NEXT 4000 , O(") CHARACTER
TARGETTYPE NEXT 4000 , O(") CHARACTER
OPERATIONNAME NEXT 4000 , O(") CHARACTER
FUNCTIONSTATUS NEXT 4000 , O(") CHARACTER
PAGEID NEXT 4000 , O(") CHARACTER
BN NEXT 4000 , O(") CHARACTER
JOBID NEXT 4000 , O(") CHARACTER
RID NEXT 4000 , O(") CHARACTER
JOBTYPE NEXT 4000 , O(") CHARACTER
UID NEXT 4000 , O(") CHARACTER
TECHREGION NEXT 4000 , O(") CHARACTER
MGMTREPORTINGFUNCTION NEXT 4000 , O(") CHARACTER
RECORDPUBLISHINDICATOR NEXT 4000 , O(") CHARACTER
VERSION NEXT 4000 , O(") CHARACTER
SQL*Loader-926: OCI error while executing delete/truncate (due to REPLACE/TRUNCATE keyword) for table report.agt_prod_stag
ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired