本文共 1560 字,大约阅读时间需要 5 分钟。
今天需要导一些数据,从excel导入到数据库中。
然后调用sql*loader来导入了。粗放一点,其他的日志文件就不指定了。
sqlldr userid=n1/n1@xxxx control=a.ctl
DUM1102 /oravl01/oracle> sqlldr userid=n1/n1@xxxx control='/oravl01/oracle/a.ctl'
SQL*Loader: Release 11.2.0.2.0 - Production on Fri Mar 21 17:16:58 2014
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Commit point reached - logical record count 64
140314_124138,007yxsxdz7p0h,13721913,165027,1,30.93^M
用dosux或者dos2unix格式化一把。
DUM1102 /oravl01/oracle> sqlldr userid=n1/n1@xxxx control=a.ctl data=a.data
SQL*Loader: Release 11.2.0.2.0 - Production on Fri Mar 21 17:36:44 2014
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Commit point reached - logical record count 64Commit point reached - logical record count 128Commit point reached - logical record count 192Commit point reached - logical record count 256Commit point reached - logical record count 320Commit point reached - logical record count 384Commit point reached - logical record count 448Commit point reached - logical record count 512Commit point reached - logical record count 576Commit point reached - logical record count 640Commit point reached - logical record count 704Commit point reached - logical record count 768Commit point reached - logical record count 832Commit point reached - logical record count 896Commit point reached - logical record count 922
SQL*Plus: Release 11.2.0.2.0 Production on Fri Mar 21 17:36:51 2014
Copyright (c) 1982, 2010, Oracle. All rights reserved.
SQL> select count(*)from sql_summary;
COUNT(*) 922
转载地址:https://jeanron100.blog.csdn.net/article/details/102506774 如侵犯您的版权,请留言回复原文章的地址,我们会给您删除此文章,给您带来不便请您谅解!