ORACLE export / import 예제

Using Command-Line Keywords
Keywords are optionally separated by commas. They are entered in any order. Keywords are followed by valid arguments.

For example:

SQLLDR CONTROL=foo.ctl, LOG=bar.log, BAD=baz.bad, DATA=etc.dat
USERID=scott/tiger, ERRORS=999, LOAD=2000, DISCARD=toss.dis,
DISCARDMAX=5

최초 insert할 때 control file
==============================
LOAD DATA
badfile apt.bad
insert into table tb_bill
fields terminated by ','
(yymmdd,biller_code,bill_code,biller_uid,present_date,present_amt,due_date,pay_type,totpayamt)


append할때 control file
=========================
LOAD DATA
badfile apt.bad
append into table tb_bill
fields terminated by ','
(yymmdd,biller_code,bill_code,biller_uid,present_date,present_amt,due_date,pay_type)

#sqlldr userid=xxx/yyy control=apt01.ctl log=apt.log data=apt.txt

그리고 apt.log를 확인하여 결과를 확인할 것

참고
http://www.aend.co.kr/aend/DOC/database.804/a58244/ch06.htm#496