SQL*Loader-503: Error appending extension to file Additional information: 7217
Hello ,
The SQL loader for the bank loader program is working fine in all instance except one and displaying the above error in that particular instance.
Can anybody suggest anything regarding this error as its urgent. The control file details are below:
--
-- $Header: ATC_COL_CITIBANK.ctl 12.1 1:50 PM 03/28/2012 Apps Associates $ |
--
LOAD DATA
REPLACE
INTO TABLE ce_stmt_int_tmp
FIELDS TERMINATED BY '|'
TRAILING NULLCOLS
(rec_no RECNUM,
rec_id_no "ltrim(rtrim(:rec_id_no))",
column1 "ltrim(rtrim(:column1))",
column2 "ltrim(rtrim(:column2))",
column3 "ltrim(rtrim(:column3))",
column4 "ltrim(rtrim(:column4))",
--column5 "ltrim(rtrim(:column5))",
column5 "ltrim(rtrim(REGEXP_REPLACE(:column5 , '[^a-zA-Z0-9~`!