重庆思庄Oracle、Redhat认证学习论坛
标题:
SQLLOADER express加载数据报 KUP-04040
[打印本页]
作者:
郑全
时间:
2022-7-2 11:25
标题:
SQLLOADER express加载数据报 KUP-04040
sqlldr sztech/sztech@pdb1 table=emp
SQL*Loader-807: error loading table
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-04040: file emp.dat in SYS_SQLLDR_XT_TMPDIR_00000 not found
[oracle@dbserver ~]$ sqlldr sztech/sztech@pdb1 table=emp
SQL*Loader: Release 19.0.0.0.0 - Production on Sat Jul 2 11:25:38 2022
Version 19.15.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
Express Mode Load, Table: EMP
Path used: External Table, DEGREE_OF_PARALLELISM=AUTO
SQL*Loader-807: error loading table
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-04040: file emp.dat in SYS_SQLLDR_XT_TMPDIR_00000 not found
Table EMP:
0 Rows successfully loaded.
Check the log files:
emp.log
emp_%p.log_xt
for more information about the load.
作者:
郑全
时间:
2022-7-2 11:57
这个问题,主要是 当前文件放在 /home/oracle 目录下导致,
由于GRID用户无法访问 /HOME/ORACLE 目录,因此报错,可以把文件放到/tmp下去,即可。
再在/tmp下去执行sqlldr即可。
欢迎光临 重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)
Powered by Discuz! X3.2