Hi Frnds,
I wanto load the data thats in data file with comma(,) delimited.
it throw this errors
SQL*Loader-951: Error calling once/load initialization
ORA-00604: error occurred at recursive SQL level 1
ORA-00054: resource busy and acquire with NOWAIT specified
Plz look at my file below . plz give me a solution
my .ctl file
LOAD DATA
APPEND
INTO TABLE STN.STN_ERROR_TABLE
FIELDS TERMINATED BY ','
TRAILING NULLCOLS
(
TGT_SCHEMA_NAME,
TGT_TABLE_NAME,
REJECTED_RECORD,
ERROR_CODE,
SOURCE_SYS_NAME,
SESSION_LOG_NAME,
ETL_RUN_DT
)
and my .csv or data file as below
STN,STN_SAP_MATERIAL_ATTR,MASTER_MATERIAL_ATTR_090709,00900
STN,STN_SAP_MATERIAL_ATTR,MASTER_MATERIAL_ATTR_090709,00900
STN,STN_SAP_MATERIAL_ATTR,MASTER_MATERIAL_ATTR_090709,00900.
.
.