sqlldr memo

call

export NLS_LANG=American_America.AL32UTF8

sqlldr.exe dolmen/dolmen control=lts_in_test.ctr data=lts_in_test.csv log=asd.log bad=asd.bad

control file example

LOAD INTO TABLE LOCAL_TELE_STATION_IN replace FIELDS TERMINATED ',' (

    ID_STATION_IN                      integer,

    DESCRIPTION                        CHAR(1024),

    ADDRESS_NUMBER                     CHAR(255),

    POSTAL_CODE                        CHAR(20),

    MUNICIPALITY                       CHAR(40),

    PROVINCE                           CHAR(4)

)