RDBMS 11GR2.
I've to load a Fixed-Width file (CHARACTERSET I8EBCDIC1144) into a Oracle Table.
There's a problem with the VARCHAR2 column.
The error is
Variable length field exceeds maximum length.
The ctl file is:
OPTIONS ( DIRECT=TRUE)
UNRECOVERABLE LOAD DATA
CHARACTERSET I8EBCDIC1144
LENGTH SEMANTICS CHAR
INFILE '/data/XXXX.dat' "FIX 1747"
BADFILE 'XXXX.bad'
DISCARDFILE 'XXXX.log'
TRUNCATE
PRESERVE BLANKS
INTO TABLE TAB
(
col1 POSITION(1: 2) CHAR,
col2 POSITION(3: 11) CHAR,
col3 POSITION(12: 13) DECIMAL(3,0),
col4 POSITION(14: 16) DECIMAL(5,0),
col5 POSITION(17: 42) TIMESTAMP (6) "YYYY-MM-DD-HH24.MI.SS.FF",
col6 POSITION(43: 68) TIMESTAMP (6) "YYYY-MM-DD-HH24.MI.SS.FF",
col7 POSITION(69: 94) TIMESTAMP (6) "YYYY-MM-DD-HH24.MI.SS.FF",
col8 POSITION(95: 104) DATE "DD-MM-YYYY",
col9 POSITION(105: 1706) VARCHAR,
......
)
The log fle is
Record 1: Rejected - Error on table TAB, column col9.
Variable length field exceeds maximum length.
MAXIMUM ERROR COUNT EXCEEDED - Above statistics reflect partial run.
Edited by: AleC on 5-giu-2012 9.34