[oracle@www ~]$ cat users.logSQL*Loader: Release 11.2.0.1.0 - Production on Fri Dec 30 06:46:38 2011Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.Control File: users.ctl
Data File: /home/oracle/users.txt
Bad File: users.bad
Discard File: none specified
(Allow all discards)Number to load: ALL
Number to skip: 1
Errors allowed: 50
Bind array: 100 rows, maximum of 256000 bytes
Continuation: none specified
Path used: ConventionalTable USERS, loaded from every logical record.
Insert option in effect for this table: TRUNCATE
TRAILING NULLCOLS option in effect Column Name Position Len Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
USER_ID FIRST * WHT O(X00) CHARACTER
USER_NAME NEXT * WHT O(X00) CHARACTER
LOGIN_TIMES NEXT * WHT O(X00) CHARACTER
LAST_LOGIN NEXT * WHT O(X00) DATE YYYY-MM-DD HH24:MI:SSRecord 1: Discarded - all columns null.
Record 2: Rejected - Error on table USERS, column USER_ID.
second enclosure string not present
Record 3: Rejected - Error on table USERS, column USER_ID.
second enclosure string not present
Record 4: Rejected - Error on table USERS, column USER_ID.
second enclosure string not present
Record 5: Rejected - Error on table USERS, column USER_ID.
second enclosure string not presentTable USERS:
0 Rows successfully loaded.
4 Rows not loaded due to data errors.
0 Rows not loaded because all WHEN clauses were failed.
1 Row not loaded because all fields were null.
Space allocated for bind array: 103200 bytes(100 rows)
Read buffer bytes: 1048576Total logical records skipped: 1
Total logical records read: 5
Total logical records rejected: 4
Total logical records discarded: 1Run began on Fri Dec 30 06:46:38 2011
Run ended on Fri Dec 30 06:46:38 2011Elapsed time was: 00:00:00.18
CPU time was: 00:00:00.02
Data File: /home/oracle/users.txt
Bad File: users.bad
Discard File: none specified
(Allow all discards)Number to load: ALL
Number to skip: 1
Errors allowed: 50
Bind array: 100 rows, maximum of 256000 bytes
Continuation: none specified
Path used: ConventionalTable USERS, loaded from every logical record.
Insert option in effect for this table: TRUNCATE
TRAILING NULLCOLS option in effect Column Name Position Len Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
USER_ID FIRST * WHT O(X00) CHARACTER
USER_NAME NEXT * WHT O(X00) CHARACTER
LOGIN_TIMES NEXT * WHT O(X00) CHARACTER
LAST_LOGIN NEXT * WHT O(X00) DATE YYYY-MM-DD HH24:MI:SSRecord 1: Discarded - all columns null.
Record 2: Rejected - Error on table USERS, column USER_ID.
second enclosure string not present
Record 3: Rejected - Error on table USERS, column USER_ID.
second enclosure string not present
Record 4: Rejected - Error on table USERS, column USER_ID.
second enclosure string not present
Record 5: Rejected - Error on table USERS, column USER_ID.
second enclosure string not presentTable USERS:
0 Rows successfully loaded.
4 Rows not loaded due to data errors.
0 Rows not loaded because all WHEN clauses were failed.
1 Row not loaded because all fields were null.
Space allocated for bind array: 103200 bytes(100 rows)
Read buffer bytes: 1048576Total logical records skipped: 1
Total logical records read: 5
Total logical records rejected: 4
Total logical records discarded: 1Run began on Fri Dec 30 06:46:38 2011
Run ended on Fri Dec 30 06:46:38 2011Elapsed time was: 00:00:00.18
CPU time was: 00:00:00.02
解决方案 »
- 求一存储过程,能根据不同的报表名称(物理表名),实现对需要的字段进行汇总。
- 多个or条件不走索引,求解
- oracle求解惑,求各位高手。
- 获取每秒Oracle数据库删除数据的记录
- 请教个case when的问题
- 这什么原因: v_char:=v_date,则从2050年开始,v_char会比v_date少100年
- ORACLE中类似的视图如何来建?
- 大家好,我的oracle8.17装完用system/manager进来出现ora-01031:insufficient privileges该什么办
- 有高手在c++中用Odatabase (oracle 公司提供的oledb)访问数据库嘛?
- 100分请教
- oracle数据库中 怎么去掉非汉字的字符,并选择出2个或3个汉字的 数据
- oracle sqlloder 出错
把
optionally enclosed by "" --表中的每列数据用""框起来,当数据中有' 时
改为
optionally enclosed by '\''
因为在你的原始数据中,姓名字段中有单引号出现。其实本来写成enclosed by '''就可以,但是这里还需要在中间的单引号前面加一个转义字符\