oracle 載入文字檔案

oracle 載入文字檔案
1.編寫控制檔案 input.ctl
LOAD DATA INFILE 'c:1.txt'
APPEND INTO TABLE houzi
FIELDS TERMINATED BY ","
(no1,no2,no3)
2.執行控制檔案
C:Documents and Settingshp>sqlldr control=c:input.ct
l

SQL*Loader: Release 9.2.0.1.0 - Production on Wed Aug 27 15:18:01 2008

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Commit point reached - logical record count 3
Commit point reached - logical record count 4

[@more@]