17,377
社区成员
发帖
与我相关
我的任务
分享
C:\>sqlplus test/test
SQL*Plus: Release 9.2.0.1.0 - Production on Mon Oct 13 13:32:11 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
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> create table t(
2 f1 varchar2(30),
3 f2 varchar2(30),
4 f3 varchar2(30),
5 f4 varchar2(30),
6 f5 varchar2(30),
7 f6 varchar2(30),
8 f7 varchar2(30),
9 f8 varchar2(30),
10 f9 varchar2(30),
11 f10 varchar2(30),
12 f11 varchar2(30),
13 f12 varchar2(30),
14 f13 varchar2(30),
15 f14 varchar2(30),
16 f15 varchar2(30),
17 f16 varchar2(30),
18 f17 varchar2(30),
19 f18 varchar2(30)
20 );
Table created.
SQL> exit
Disconnected from 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:\>cd C:\test\New Folder
C:\test\New Folder>dir
Volume in drive C is Local Disk
Volume Serial Number is 507A-5FAF
Directory of C:\test\New Folder
10/13/08 13:28 <DIR> .
10/13/08 13:28 <DIR> ..
10/13/08 13:25 259 data.dat
10/13/08 13:27 343 ldr.ctl
2 File(s) 602 bytes
2 Dir(s) 20,581,208,064 bytes free
C:\test\New Folder>sqlldr userid=test/test control=ldr.ctl
SQL*Loader: Release 9.2.0.1.0 - Production on Mon Oct 13 13:37:13 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Commit point reached - logical record count 1
SQL> conn test/test@orcl
Connected to Oracle9i Enterprise Edition Release 9.2.0.1.0
Connected as test
SQL> select * from t;
F1 F2 F3 F4 F5 F6 F7 F8 F9 F10 F11 F12 F13 F14 F15 F16 F17 F18
------------------------------ ------------------------------ ------------------------------ ------------------------------ ------------------------------ ------------------------------ ------------------------------ ------------------------------ ------------------------------ ------------------------------ ------------------------------ ------------------------------ ------------------------------ ------------------------------ ------------------------------ ------------------------------ ------------------------------ --------------------------------------------------------------------------------
1 0477 47711 伊旗 22B 公客 0 城市 47300126 亲情无限1+1 120101 聚类市场 48300231 基础商品_鄂尔多斯甲种ADSL
SQL>