Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Data file for external table
I have a column defined as:
MER_DOD_REQUIRED_IND CHAR (255) Terminated by "," Trim whitespace same as SQL Loaderreturning this error:
error processing column MER_DOD_REQUIRED_IND in row 4 for datafile
c:\wip\me_icd9_code.txt
ORA-01401: inserted value too large for column
after attempting to execute this:
SQL> insert /*+ append */ into me_icd9_code select * from
me_icd9_code_ext;
insert /*+ append */ into me_icd9_code select * from me_icd9_code_ext
*
ERROR at line 1:
ORA-29913: error in executing ODCIEXTTABLEFETCH callout ORA-30653: reject limit reached ORA-06512: at "SYS.ORACLE_LOADER", line 14 ORA-06512: at line 1
I looked at the data file and that 4th record third column has a space
right after the comma.
Why is that a problem?
Received on Tue Apr 12 2005 - 11:06:55 CDT