I defined an external table with 2 columns. One column is Error_cd varchar2 (100) and another as Error_Desc varchar2(500).
The definition is as follows:
CREATE TABLE my_ext_tab ( error_cd
VARCHAR2(500) ) ORGANIZATION EXTERNAL ( TYPE ORACLE_LOADER DEFAULT DIRECTORY my_dir ACCESS PARAMETERS
( RECORDS DELIMITED BY NEWLINE BADFILE my_bad_dir:'%a_%p.bad' LOGFILE my_log_dir:'%a_%p.log' FIELDS TERMINATED BY '~' MISSING FIELD VALUES ARE NULL ) LOCATION ('my_file.txt') ) REJECT LIMIT UNLIMITED /
While i am querying external tables, some records are rejected and placed in bad file. When I verify the log, it's showing the following error messages.
KUP-04021: field formatting error for field ERROR_DESC KUP-04026: field too long for datatype KUP-04101: record 14 rejected in file my_file.txt
Then I verified the length of Error_Desc field. But its lenght is 252. I am surprized why oracle throughs an error. Is there any charcterset problem?
Any ideas please.?