티스토리 뷰

컴퓨터활용/오라클

ORACLE export / import 예제

호주 멜번초이 2003.10.12 01:08
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

'컴퓨터활용 > 오라클' 카테고리의 다른 글

오라클 유저 생성  (0) 2003.10.12
oracle listener status check  (0) 2003.10.12
ORACLE export / import 예제  (0) 2003.10.12
ORACLE DATA DICTIONARY TABLE  (0) 2003.10.12
PRIMARY KEY 생성하기  (0) 2003.10.12
MYSQL 주의점  (1) 2003.10.12
댓글
댓글쓰기 폼