Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

sqlloader error

chandra_1986May 19 2021

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

Comments

Post Details

Added on May 19 2021
6 comments
193 views