I have the same ldr file on two different windows computers, one running 12.1 one running 12.2 or Oracle DB (standard)
One loads fine, one gets a 1821 error, doesn't even try to load rows.
I've tried to find where there is an error reported, but no luck so far. Can't update the 12.1 database. (stupid vendor "compatibility" requirements)
ldr file looks like:
Options (Skip=1)
UNRECOVERABLE
LOAD DATA
INFILE file.txt
APPEND
INTO TABLE "tablename"
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS (
file_type FILLER,
IDnumber ,
another_ID ,
SDATE TIMESTAMP "YYYYMMDDHH24MISS",
EDATE ,
COMMENTS ,
ENTERED_BY ,
ENTRY_DATETIME TIMESTAMP "YYYYMMDDHH24MISS",
a_SEQNO SEQUENCE(100,1),
SYSDT "sysdate")
Thanks for any help