C:\Documents and Settings\supe>sqlldr system/tt1018 control='C:\Documents and Se
ttings\supe\Desktop\sqlload' external_table=execute log='C:\Documents and Settings\supe\Desktop\log'
SQL*Loader: Release 10.1.0.2.0 - Production on 星期二 7月 18 16:54:27 2006
Copyright (c) 1982, 2004, Oracle.All rights reserved.
SQL*Loader-807:加载表时出错
ORA-29913: 执行 ODCIEXTTABLEOPEN 调出时出错
ORA-29400: 数据插件错误KUP-00554: error encountered while parsing access parameters
KUP-01006: error signalled during parse of access parameters
KUP-00562: unknown escape sequence
ORA-06512: 在 "SYS.ORACLE_LOADER", line 19
ORA-06512: 在 line 1
CONTROL FILE:
load data
infile *
into table dept
truncate
fields terminated by ','
(dept ,
name ,
loc)
begindata
10,Sales,Virginia
20,Accounting,Virginia
30,Consulting,Virginia
40,Finance,Virginia
LOGFILE:
SQL*Loader: Release 10.1.0.2.0 - Production on 星期二 7月 18 16:54:27 2006
Copyright (c) 1982, 2004, Oracle.All rights reserved.
控制文件:C:\Documents and Settings\supe\Desktop\sqlload.ctl
数据文件: C:\Documents and Settings\supe\Desktop\sqlload.ctl
错误文件:C:\Documents and Settings\supe\Desktop\sqlload.bad
废弃文件: 未作指定
:
(可废弃所有记录)
要加载的数: ALL
要跳过的数: 0
允许的错误: 50
继续:未作指定
所用路径: 外部表
表 DEPT,已加载从每个逻辑记录
插入选项对此表 TRUNCATE 生效
列名
位置长度中止 包装数据类型
------------------------------ ---------- ----- ---- ---- ---------------------
DEPT
FIRST * , CHARACTER
NAME
NEXT * , CHARACTER
LOC
NEXT * , CHARACTER
已创建临时目录对象 SYS_SQLLDR_XT_TMPDIR_00000, 用于路径 C:\Documents and Settings\supe\Desktop\
正在创建外部表 "SYS_SQLLDR_X_EXT_DEPT"
CREATE TABLE "SYS_SQLLDR_X_EXT_DEPT"
(
"DEPT" NUMBER(2),
"NAME" VARCHAR2(14),
"LOC" VARCHAR2(13)
)
ORGANIZATION external
(
TYPE oracle_loader
DEFAULT DIRECTORY SYS_SQLLDR_XT_TMPDIR_00000
ACCESS PARAMETERS
(
RECORDS DELIMITED BY NEWLINE CHARACTERSET ZHS16GBK
BADFILE 'SYS_SQLLDR_XT_TMPDIR_00000':'sqlload.bad'
LOGFILE 'C:\Documents and Settings\supe\Desktop\log.log_xt'
READSIZE 1048576
SKIP 9
FIELDS TERMINATED BY "," LDRTRIM
REJECT ROWS WITH ALL NULL FIELDS
(
"DEPT" CHAR(255)
TERMINATED BY ",",
"NAME" CHAR(255)
TERMINATED BY ",",
"LOC" CHAR(255)
TERMINATED BY ","
)
)
location
(
'sqlload.ctl'
)
)REJECT LIMIT UNLIMITED
正在执行 INSERT 语句来加载数据库表 DEPT
INSERT /*+ append */ INTO DEPT
(
DEPT,
NAME,
LOC
)
SELECT
"DEPT",
"NAME",
"LOC"
FROM "SYS_SQLLDR_X_EXT_DEPT"
SQL*Loader-807:加载表时出错
ORA-29913: 执行 ODCIEXTTABLEOPEN 调出时出错
ORA-29400: 数据插件错误KUP-00554: error encountered while parsing access parameters
KUP-01006: error signalled during parse of access parameters
KUP-00562: unknown escape sequence
ORA-06512: 在 "SYS.ORACLE_LOADER", line 19
ORA-06512: 在 line 1
正在删除外部表 "SYS_SQLLDR_X_EXT_DEPT"
表 DEPT:
0 行 加载成功。
从 星期二 7月18 16:54:27 2006 开始运行
在 星期二 7月18 16:54:44 2006 处运行结束
经过时间为: 00: 00: 17.71
CPU 时间为: 00: 00: 00.06
|
