ctl是什么oracle,SQLLDR的一个CTL样例

LOAD DATA

INFILE 'E:\84db\ot_patent2008-06-29 12-27-20.txt'

BADFILE 'E:\84db\ot_patent2008-06-29 12-27-20.bad'

DISCARDFILE 'E:\84db\ot_patent2008-06-29 12-27-20.dsc'

INTO TABLE "HPS"."OT_PATENT"

FIELDS TERMINATED BY '|'

TRAILING NULLCOLS

(ID,

NAME char(4000),

APPLY_NUMBER char(4000),

APPLY_DATE char(4000),

PUBLISH_NUMBER char(4000),

PUBLISH_DATE char(4000),

PROPOSER char(4000),

ADDRESS char(4000),

MAIN_CLASS char(4000),

ANTIBODY_CLASS char(4000),

ORIGINATOR char(4000),

DEPUTY char(4000),

DEPUTY_INSTITUTION char(4000),

URL char(4000),

COUNTRY char(4000),

LAWSTATE0 char(4000),

LAWSTATE1 char(4000),

LAWSTATE2 char(4000),

LAWSTATE3 char(4000),

LAWSTATE4 char(4000),

LAWSTATE5 char(4000),

CURRENTSTATE char(4000),

PCT_APPLY_NUMBER char(4000),

PCT_APPLY_DATE char(4000),

PCT_OPEN_NUMBER char(4000),

PCT_OPEN_DATE char(4000),

PCT_IN_COUNTRY_DATE char(4000),

MAIN_POWER char(4000),

PROVINCE char(4000),

EUROPE_CLASS char(4000),

PATENT_FAMILY char(4000),

UPDATE_TIME char(4000),

DOCTYPE char(4000),

PRIORITY)