SQL> conn sm2/sm2
已连接。
SQL> create table temp (name varchar2(20),id varchar2(5),jc varchar2(20));

表已创建。

SQL> exit
从Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production中断开

C:Documents and SettingsForeverLee>sqlldr sm2/sm2

control = E:mytestsqlloaderctl.sql

SQL*Loader: Release 9.2.0.1.0 - Production on 星期二 1月 25 23:44:36 2005

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

达到提交点，逻辑记录计数2
达到提交点，逻辑记录计数3

C:Documents and SettingsForeverLee>sqlplus sm2/sm2

SQL*Plus: Release 9.2.0.1.0 - Production on 星期二 1月 25 23:45:07 2005

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

连接到:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

SQL> select * from temp;

NAME                 ID    JC
-------------------- ----- --------------------
北京                 0010  beijing
广州                 0020  guangzhou
海淀                 0198  haidian

SQL> conn sm2/sm2
已连接。
SQL> create table temp (name varchar2(20),id varchar2(5),jc varchar2(20));

表已创建。

SQL> exit
从Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production中断开

C:Documents and SettingsForeverLee>sqlldr sm2/sm2

control = E:mytestsqlloaderctl.sql

SQL*Loader: Release 9.2.0.1.0 - Production on 星期二 1月 25 23:44:36 2005

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

达到提交点，逻辑记录计数2
达到提交点，逻辑记录计数3

C:Documents and SettingsForeverLee>sqlplus sm2/sm2

SQL*Plus: Release 9.2.0.1.0 - Production on 星期二 1月 25 23:45:07 2005

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

连接到:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

SQL> select * from temp;

NAME                 ID    JC
-------------------- ----- --------------------
北京                 0010  beijing
广州                 0020  guangzhou
海淀                 0198  haidian

控制文件ctl.sql

load data
infile 'E:mytestsqlloaderdata.sql'
into table temp
( name char terminated by ',',  --根据','分割
  id char terminated by ',',
  jc char terminated by whitespace) --根据空格区分一行

数据文件data.sql

北京,0010,beijing
广州,0020,guangzhou
海淀,0198,haidian