實例講解sqlldr加載數據到不同表的問題:
◆首先我們來創建測試表:
D:\Orion>sqlplus eygle/eygle
SQL*Plus: Release 9.2.0.6.0 - Production on 星期一 11月 11 12::20 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:53:59 SQL> create table test1 (
19:54:14 2 a1 varchar2(10),
19:54:21 3 a2 varchar2(10),
19:54:26 4 a3 varchar2(10));
表已創建。
已用