Use sqlldr in Oracle

1. Create a control file

Options (direct = true)
Load data
Infile '/var/log/xferlog. tmplog'
Into table ta_ftp_log
Append
Fields terminated by '|'
Trailing nullcols
(
LOGID integer external,
Invoketime DATE 'yyyymmdd hh24: mi: ss ',
Interfacename char,
Interfacetype char,
Invokesysname char,
Transfertime integer external,
Transfertyep char,
Specialflag char,
Transferto char,
Model char,
Username char,
Status char,
Filename char
)

2. Use the sqlldr command

Sqlldr jiang/jiang@10.137.17.129/ora11g control =/var/log/ta_ftp_log.ctl log =/var/log/ta_ftp_log.log errors = 2000 (Note: errors the number of error lines generated each time)