cmd------------》
sqlldr ssi/ssi@orcl control=D:\workspace1\web\webapp\ctl\temp_bfhposlc.ctl data=D:\\UploadFile\\a-20110708-bfhposlc.bin
result-----------》
SQL*Loader: Release 10.1.0.2.0 - Production on 星期三 9月 14 11:00:09 2011Copyright (c) 1982, 2004, Oracle. All rights reserved.Commit point reached - logical record count 64数据库以前是在服务器上,现在移到了本机上测试,结果数据库里没有数据。我第一次用sqlldr请高手详细说一下是怎么回事的错误啊。如果是这样执行:
C:\Documents and Settings\Administrator>sqlldr ssi/ssi@orcl;control = D:\workspace1\web\webapp\ctl\temp_bfhrppos.ctl;
SQL*Loader: Release 10.1.0.2.0 - Production on 星期三 9月 14 11:08:29 2011Copyright (c) 1982, 2004, Oracle. All rights reserved.SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0]
ORA-12154: TNS:could not resolve the connect identifier specifiedC:\Documents and Settings\Administrator>如果是这样执行
C:\Documents and Settings\Administrator>sqlldr ssi/ssi;control = D:\workspace1\web\webapp\ctl\temp_bfhrppos.ctl;
SQL*Loader: Release 10.1.0.2.0 - Production on 星期三 9月 14 11:09:29 2011Copyright (c) 1982, 2004, Oracle. All rights reserved.SQL*Loader-128: unable to begin a session
ORA-01017: invalid username/password; logon deniedssi是我自己建的数据库,用pl/sql登陆是没有问题的啊。以前没做过,是不是需要修改什么配置什么的,有人知道吗请说详细点啊
sqlldr ssi/ssi@orcl control=D:\workspace1\web\webapp\ctl\temp_bfhposlc.ctl data=D:\\UploadFile\\a-20110708-bfhposlc.bin
result-----------》
SQL*Loader: Release 10.1.0.2.0 - Production on 星期三 9月 14 11:00:09 2011Copyright (c) 1982, 2004, Oracle. All rights reserved.Commit point reached - logical record count 64数据库以前是在服务器上,现在移到了本机上测试,结果数据库里没有数据。我第一次用sqlldr请高手详细说一下是怎么回事的错误啊。如果是这样执行:
C:\Documents and Settings\Administrator>sqlldr ssi/ssi@orcl;control = D:\workspace1\web\webapp\ctl\temp_bfhrppos.ctl;
SQL*Loader: Release 10.1.0.2.0 - Production on 星期三 9月 14 11:08:29 2011Copyright (c) 1982, 2004, Oracle. All rights reserved.SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0]
ORA-12154: TNS:could not resolve the connect identifier specifiedC:\Documents and Settings\Administrator>如果是这样执行
C:\Documents and Settings\Administrator>sqlldr ssi/ssi;control = D:\workspace1\web\webapp\ctl\temp_bfhrppos.ctl;
SQL*Loader: Release 10.1.0.2.0 - Production on 星期三 9月 14 11:09:29 2011Copyright (c) 1982, 2004, Oracle. All rights reserved.SQL*Loader-128: unable to begin a session
ORA-01017: invalid username/password; logon deniedssi是我自己建的数据库,用pl/sql登陆是没有问题的啊。以前没做过,是不是需要修改什么配置什么的,有人知道吗请说详细点啊
C:\Documents and Settings\Administrator>sqlldr ssi/ssi control=D:\workspace1\we
b\webapp\ctl\temp_bfhposlc.ctl data=D:\\UploadFile\\a-20110708-bfhposlc.bin;
SQL*Loader: Release 10.1.0.2.0 - Production on 星期三 9月 14 11:14:14 2011Copyright (c) 1982, 2004, Oracle. All rights reserved.SQL*Loader-500: Unable to open file (D:\\UploadFile\\a-20110708-bfhposlc.bin;)
SQL*Loader-553: file not found
SQL*Loader-509: System error: 系统找不到指定的文件。
SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.C:\Documents and Settings\Administrator>sqlldr ssi/ssi; control=D:\workspace1\w
eb\webapp\ctl\temp_bfhposlc.ctl data=D:\\UploadFile\\a-20110708-bfhposlc.bin;
SQL*Loader: Release 10.1.0.2.0 - Production on 星期三 9月 14 11:14:30 2011Copyright (c) 1982, 2004, Oracle. All rights reserved.SQL*Loader-128: unable to begin a session
ORA-01017: invalid username/password; logon deniedC:\Documents and Settings\Administrator>
eb\webapp\ctl\temp_bfhposlc.ctl data=D:\\UploadFile\\a-20110708-bfhposlc.bin;这不是我写的,怎么前面是\ 后面是\\ 干啊 ;到底加不加
你在 ssi/ssi 后面加一个分号,会把分号算到密码里去,所以报用户名或密码错误的问题你上面那个是报无法打开文件 data=d:\uploadfile\a-20110708-bfhposlc.bin 就可以了,不需要加 \\
2011 11:19:16Copyright (c) 1997, 2003, Oracle. All rights reserved.Used parameter files:
D:\oracle\product\10.1.0\Db_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = WWW-98E4
CB5A7F6)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl
)))
OK (30 msec)C:\Documents and Settings\Administrator>
没问题啊,我用户名密码没错啊!!
sqlldr ssi/ssi control=D:\workspace1\we
b\webapp\ctl\temp_bfhposlc.ctl data=D:\UploadFile\a-20110708-bfhposlc.binSQL*Loader: Release 10.1.0.2.0 - Production on 星期三 9月 14 11:21:39 2011Copyright (c) 1982, 2004, Oracle. All rights reserved.Commit point reached - logical record count 64
加了就这样,怎么找不到呢C:\Documents and Settings\Administrator>sqlldr ssi/ssi control=D:\workspace1\we
b\webapp\ctl\temp_bfhposlc.ctl data=D:\UploadFile\a-20110708-bfhposlc.bin;SQL*Loader: Release 10.1.0.2.0 - Production on 星期三 9月 14 11:21:43 2011Copyright (c) 1982, 2004, Oracle. All rights reserved.SQL*Loader-500: Unable to open file (D:\UploadFile\a-20110708-bfhposlc.bin;)
SQL*Loader-553: file not found
SQL*Loader-509: System error: 系统找不到指定的文件。
SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.C:\Documents and Settings\Administrator>
data= 后面,将 \\ 换成 \
6楼已经换了 我是本地 应该不用@了 最后是这么写的C:\Documents and Settings\Administrator>sqlldr ssi/ssi control=D:\workspace1\we
b\webapp\ctl\temp_bfhposlc.ctl data=D:\UploadFile\a-20110708-bfhposlc.bin;没找到
b\webapp\ctl\temp_bfhposlc.ctl data=D:/UploadFile/a-20110708-bfhposlc.bin
SQL*Loader: Release 10.1.0.2.0 - Production on 星期三 9月 14 11:36:25 2011Copyright (c) 1982, 2004, Oracle. All rights reserved.Commit point reached - logical record count 64C:\Documents and Settings\Administrator>这个结果没有数据啊。
Commit point reached - logical record count 64这里显示,提交了 64 条记录呀
是在本地啊,几十万条数据啊。。data=D:/UploadFile/a-20110708-bfhposlc.bin
这个100多M啊
truncate into table TEMP_BFHPOSLC
trailing nullcols
(
ZONENO position(1:5) "trim(:ZONENO)",
CENBRNO position(6:10) "trim(:CENBRNO)",
ACCBRNO position(11:15) "trim(:ACCBRNO)",
BANKNO position(16:21) "trim(:BANKNO)",
TERMNO position(22:36) "trim(:TERMNO)",
CARDNO position(37:55) "trim(:CARDNO)",
ACCTNO position(56:72) "trim(:ACCTNO)",
NETSEQNO position(73:78) "trim(:NETSEQNO)",
AMOUNT position(79:96) "trim(:AMOUNT)",
DBCRF position(97:97) "trim(:DBCRF)",
REPFLAG position(98:98) "trim(:REPFLAG)",
WORKDATE position(99:108) "trim(replace(:WORKDATE,'-'))",
TRXCODE position(109:113) "trim(:TRXCODE)",
TYDWNAME position(114:173) "trim(:TYDWNAME)",
TYDWNO position(174:186) "trim(:TYDWNO)",
FEEAMT position(187:204) "trim(:FEEAMT)",
TIPAMT position(205:222) "trim(:TIPAMT)",
TIPRAT position(223:227) "trim(:TIPRAT)",
UNKNOWNC position(228:228) "trim(:UNKNOWNC)",
AUTNO position(229:234) "trim(:AUTNO)",
EXPRD position(235:244) "trim(:EXPRD)",
AUTHNO position(245:252) "trim(:AUTHNO)",
OPENBRNO position(253:257) "trim(:OPENBRNO)",
OPENLHH position(258:263) "trim(:OPENLHH)",
FRAMT position(264:281) "trim(:FRAMT)",
CARDKIND position(282:284) "trim(:CARDKIND)",
LOCALF position(285:287) "trim(:LOCALF)",
WORKTIME position(288:297) "trim(:WORKTIME)"
)
在sqlldr命令里加上log和bad参数,找找是什么原因
字段有点多...估计是控制文件里的配置和数据文件里的字段值不能对应上
前几行数据一个一个对一下吧,这么多字段,找起来会比较麻烦