SQL*Loader-605:发生不依赖数据的ORACLE错误--加载已中止
SQL*Loader-605:发生不依赖数据的ORACLE错误--加载已中止
提问于 2013-03-27 22:31:18
当我尝试加载Incl_c.ctl时，我得到了错误，所有其他控制文件都加载得很好。下面是错误：
[navy10@sit ~]$ sqlldr navy10@studb10g Incl_C.ctl
Password:
SQL*Loader: Release 10.2.0.3.0 - Production on Wed Mar 27 10:26:52 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL*Loader-2028: load discontinued to user interrupt (Ctrl-C) [103]
SQL*Loader-605: Non-data dependent ORACLE error occurred -- load discontinued.下面是Incl_C的控制文件：
LOAD DATA
INFILE 'Incl_C.dat'
REPLACE INTO TABLE Includes_C
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY "'"
(Tnum, ConfID)下面是Incl_C的.log文件：
SQL*Loader: Release 10.2.0.3.0 - Production on Wed Mar 27 10:26:52 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Control File: Incl_C.ctl
Data File: Incl_C.dat
Bad File: Incl_C.bad
Discard File: none specified
(Allow all discards)
Number to load: ALL
Number to skip: 0
Errors allowed: 50
Bind array: 64 rows, maximum of 256000 bytes
Continuation: none specified
Path used: Conventional
Table INCLUDES_C, loaded from every logical record.
Insert option in effect for this table: REPLACE
Column Name Position Len Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
TNUM FIRST * , O(') CHARACTER
CONFID NEXT * , O(') CHARACTER
Record 22: Rejected - Error on table INCLUDES_C, column TNUM.
Column not found before end of logical record (use TRAILING NULLCOLS)
SQL*Loader-2028: load discontinued to user interrupt (Ctrl-C) [103]
ORA-01013: user requested cancel of current operation
SQL*Loader-605: Non-data dependent ORACLE error occurred -- load discontinued.
Table INCLUDES_C:
0 Rows successfully loaded.
1 Row not loaded due to data errors.
0 Rows not loaded because all WHEN clauses were failed.
0 Rows not loaded because all fields were null.
Space allocated for bind array: 33024 bytes(64 rows)
Read buffer bytes: 1048576
Total logical records skipped: 0
Total logical records rejected: 1
Total logical records discarded: 0
Run began on Wed Mar 27 10:26:52 2013
Run ended on Wed Mar 27 10:27:01 2013
Elapsed time was: 00:00:09.17
CPU time was: 00:00:00.03请告诉我哪里出错了？，我无法显示Incl_C.dat中的数据。
回答 1
Stack Overflow用户
发布于 2013-06-19 10:39:16
看起来tablespace已经满了。
下面是我的代码：
select a.tablespace_name,
a.bytes / 1024 / 1024 "Sum MB",
(a.bytes - b.bytes) / 1024 / 1024 "used MB",
b.bytes / 1024 / 1024 "free MB",
round(((a.bytes - b.bytes) / a.bytes) * 100, 2)||'%' "percent_used"
from (select tablespace_name, sum(bytes) bytes
from dba_data_files
group by tablespace_name) a,
(select tablespace_name, sum(bytes) bytes, max(bytes) largest
from dba_free_space
group by tablespace_name) b
where a.tablespace_name = b.tablespace_name
order by ((a.bytes - b.bytes) / a.bytes) desc页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/15661444
复制相关文章
相似问题
腾讯云开发者
