sqlldr使用

$ pwd
/oracle/sqldr

$ ls -ltr
total 0
-rw-r--r--    1 oracle   dba              93 Jan 21 15:08 cnaps2_dn.add
-rw-r--r--    1 oracle   dba            4263 Jan 21 15:08 cnaps_pkg_info.add
-rw-r--r--    1 oracle   dba            1419 Jan 21 15:08 create_table.sql
-rw-r--r--    1 oracle   dba             116 Jan 21 15:17 cnaps2_dn.ctl
-rw-r--r--    1 oracle   dba            1482 Jan 21 15:17 cnaps2_dn.log

控制文件内容:
$ cat  cnaps2_dn.ctl
load data
infile '/oracle/sqldr/cnaps2_dn.add'
into table cnaps2_dn  fields terminated by '|'
(
BANK_NO,
DN_VALUE
)

$ sqlldr cnaps2/cnaps2@devrac1 control=./cnaps2_dn.ctl

SQL*Loader: Release 10.2.0.4.0 - Production on Tue Jan 21 15:17:42 2014

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

Commit point reached - logical record count 1

$ sqlldr cnaps2/cnaps2@devrac1 control=./cnaps_pkg_info.ctl

SQL*Loader: Release 10.2.0.4.0 - Production on Tue Jan 21 15:49:17 2014

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

Commit point reached - logical record count 64
Commit point reached - logical record count 128
Commit point reached - logical record count 192
Commit point reached - logical record count 194

APPEND INTO :向表里追加数据

TRUNCATE :truncate 方式删除

rows -- 常规路径绑定数组中或直接路径保存数据间的行数
          (默认: 常规路径 64, 所有直接路径)

 

 

转载于:https://www.cnblogs.com/zhaoyangjian724/p/3797948.html