由于导入参数配置表中数据有xml格式的内容,所以包含很多换行的数据,试了好久,问题都没有解决,请大侠指导!
下面是报错日志:
$ cat TASK_SPEC_PLUG.log
SQL*Loader: Release 10.2.0.4.0 - Production on Wed Jul 31 16:01:04 2013
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Control File: ./CTL/TASK_SPEC_PLUG.ctl
Data File: ./TEXT/TASK_SPEC_PLUG.txt
File processing option string: "fix 1500"
Bad File: ./BAD/TASK_SPEC_PLUG.bad
Discard File: none specified
(Allow all discards)
Number to load: ALL
Number to skip: 0
Errors allowed: 50
Bind array: 10000 rows, maximum of 20971520 bytes
Continuation: none specified
Path used: Conventional
Table TASK_SPEC_PLUG, loaded from every logical record.
Insert option in effect for this table: APPEND
Column Name Position