oracle ctl产生.bad文件,sqlldr不产生bad文件的问题

在做sqlldr时

如果数据库中目标表非空

导入失败

请问如何使其产生bad文件?

脚本如下:

sqlldr command:

D:\test>sqlldr ctaisxcz11/oracle@ctais control=DM_AJDJ.ctl bad=DM_AJDJ.bad log=DM_AJDJ.log discard= DM_AJDJ.dis rows=1000 errors=1000 bindsize=5000000

controlfile:

LOAD DATA

INFILE 'DM_AJDJ.dat'"str '|\n'"

PRESERVE BLANKS

INTO TABLE DM_AJDJ

FIELDS TERMINATED BY " ##### "

TRAILING NULLCOLS

(

AJDJ_DM,

AJDJ_MC

)

logfile:

SQL*Loader: Release 9.2.0.1.0 - Production on Tue Jul 12 10:29:34 2005

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Control File:   DM_AJDJ.ctl

Data File:      DM_AJDJ.dat

File processing option string: "str '|\n'"

Bad File:     DM_AJDJ.bad

Discard File: DM_AJDJ.dis

(Allow all discards)

Number to load: ALL

Number to skip: 0

Errors allowed: 1000

Bind array:     1000 rows, maximum of 5000000 bytes

Continuation:    none specified

Path used:      Conventional

Table DM_AJDJ, loaded from every logical record.

Insert option in effect for this table: INSERT

TRAILING NULLCOLS option in effect

Column Name                  Position   Len  Term Encl Datatype

------------------------------ ---------- ----- ---- ---- ---------------------

AJDJ_DM                             FIRST     *           CHARACTER

Terminator string : ' ##### '

AJDJ_MC                              NEXT     *           CHARACTER

Terminator string : ' ##### '

SQL*Loader-601: For INSERT option, table must be empty.  Error on table DM_AJDJ

log文件提示插入失败,但没有产生bad文件