求救：ctl文件的写法

Question

给你一个参考一下：）load data
infile '/usr/users/oracle/spool/datafile/pmC01.dat'
append
into table T_P_PMC01
fields terminated by '|'
trailing nullcols
(f1,f2,f3,f4,f5,f6,f7,f8,f9,f10,f11,f12,f13,f14,f15,f16,f17,f18,f19,f20,f21,f22,f23,f24)

Answer 1

给你一个例子
http://www.csdn.net/expert/topic/838/838225.xml?temp=.4231226
介绍一本书人民邮电出版社 《Oracle8/8i数据库系统管理》

Answer 2

load data
infile '/usr/users/oracle/spool/datafile/pmC01.dat'
append
into table T_P_PMC01
fields terminated by '|'
trailing nullcols
(f1,f2,f3,f4,f5,f6,f7,f8,f9,f10,f11,f12,f13,f14,f15,f16,f17,f18,f19,f20,f21,f22,f23,f24)
用这个就可以添加了,不用是空表.

Answer 3

我的控制文件里有append，那就是往里添加的意思

Answer 4

LOAD DATA
   INFILE 'ulcase6.dat'
   INSERT
   INTO TABLE emp
  SORTED INDEXES (empix)
  (empno POSITION(01:04) INTEGER EXTERNAL NULLIF empno=BLANKS,
   ename  POSITION(06:15)  CHAR,
   job    POSITION(17:25)  CHAR,
   mgr    POSITION(27:30)  INTEGER EXTERNAL NULLIF mgr=BLANKS,
   sal    POSITION(32:39)  DECIMAL EXTERNAL NULLIF sal=BLANKS,
   comm   POSITION(41:48)  DECIMAL EXTERNAL NULLIF comm=BLANKS,
   deptno POSITION(50:51)  INTEGER EXTERNAL NULLIF deptno=BLANKS)LOAD DATA
   INFILE 'ULCASE7.DAT'
   APPEND
   INTO TABLE emp
     WHEN (57) = '.'
   TRAILING NULLCOLS
   (hiredate SYSDATE,
      deptno POSITION(1:2)  INTEGER EXTERNAL(3)
             NULLIF deptno=BLANKS,
      job    POSITION(7:14)  CHAR  TERMINATED BY WHITESPACE
             NULLIF job=BLANKS  "UPPER(:job)",
    mgr    POSITION(28:31) INTEGER EXTERNAL 
             TERMINATED BY WHITESPACE, NULLIF mgr=BLANKS,
      ename  POSITION(34:41) CHAR 
             TERMINATED BY WHITESPACE  "UPPER(:ename)",
      empno  POSITION(45) INTEGER EXTERNAL 
             TERMINATED BY WHITESPACE,
      sal    POSITION(51) CHAR  TERMINATED BY WHITESPACE
             "TO_NUMBER(:sal,'$99,999.99')",
    comm   INTEGER EXTERNAL  ENCLOSED BY '(' AND '%'
             ":comm * 100"
   )

Answer 5

--SQLLOAD.CTLLOAD DATA
INFILE *
APPENDINTO TABLE INV.MTL_SYSTEM_ITEMS_INTERFACE
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
(
SEGMENT1,
DESCRIPTION,
PRIMARY_UNIT_OF_MEASURE,
INVENTORY_ITEM_STATUS_CODE, 
ORGANIZATION_ID,
SET_PROCESS_ID,
PROCESS_FLAG,
TRANSACTION_TYPE
)BEGINDATA
"WER-01-02","甩油环，焊接件","个","Engineer",1,1,1,"CREATE"
"WER-01-03","透盖（一），焊接件","个","Engineer",1,1,1,"CREATE"