◆加载数据

D:\Orion>sqlldr eygle/eygle errors=20000 log=data.log control=data.ctl
SQL*Loader: Release 9.2.0.6.0 - Production on 星期一 11月 11 12:23:21 2007
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

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

◆检查结果

D:\Orion>sqlplus eygle/eygle
SQL*Plus: Release 9.2.0.6.0 - Production on 星期一 11月11  12:31:29 2007
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

连接到:

Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
19:57:38 SQL> select * from test1;
A1         A2         A3
---------- ---------- ----------
01         KunMing    YunNan
已用时间:  00: 00: 00.00
19:57:42 SQL> select * from test2;

A1         A2         A3
---------- ---------- ----------
02         BeiJing    BeiJing
02         ShenZhe    ShenZhe
02         TianJin    TianJin
已用时间:  00: 00: 00.00
19:57:45 SQL> exit
从Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production中断开
 

注释：假如你不选择分区表，就可以用这个方式来直接加载数据到不同的数据表中。