External Table

   

▣ 성경을 DB로 이동시키는 방법

[oracle@orcl ~]$ cp /mnt/hgfs/pc/dbo_bible.txt ./

SCOTT> create table bible(c1 number(6), c2 number(6), c3 number(6), c4 number(6), c5 varchar2(4000));

Table created

[oracle@edrsr4p1 ~]$ cat bible.ctl

load data

characterset ko16mswin949

infile 'dbo_bible.txt'

into table bible

fields terminated by ','

(c1,c2,c3,c4,c5)

[oracle@edrsr4p1 ~]$ sqlldr scott/tiger control=bible.ctl log=bible.log direct=y

   

SQL*Loader: Release 10.2.0.1.0 - Production on Sun Aug 16 21:34:57 2009

   

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Load completed - logical record count 17812.