Hi,
My Database Version is
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
"CORE 11.2.0.3.0 Production"
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production
I am trying to load CSV flat file which has around 3 million records,it inserts around 1.5 rows and gives the following error,Can any one advise me whats the issue.
Record 1508832: Rejected - Error on table <table_name>, column <column1>.
Field in data file exceeds maximum length
Record 1509159: Rejected - Error on table <table_name>, column <column2>.
Field in data file exceeds maximum length
SQL*Loader-510: Physical record in data file (text.csv) is longer than the maximum(20971520)
SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.
Following is the control file,i added char(4000) to the columns,but facing the same errors.
OPTIONS(SKIP=1,readsize=20971520 )
LOAD DATA
REPLACE
INTO TABLE <table_name>
FIELDS TERMINATED BY ","
OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS
(
column1 char(4000) OPTIONALLY ENCLOSED BY '"',
column2 char(4000) OPTIONALLY ENCLOSED BY '"'
)
Can any one suggest what might be the issue.
Thanks,