A1:
bad file存放违反constriant的纪录.
discard file 存放违反你在控制文件里定义的过滤条件的纪录.
A2:
由于以下原因而被拒绝的记录存放在bad文件中:
● 错误的field格式,field数目不够
● 由于违反constraint而不能插入到表中
discard文件中包含的是不满足过滤条件的记录
A3:
[$#8226] Bad file: Is used by the utility to write the records that are rejected during the load
(This can occur during input record validation by the utility or during record
insertion by the Oracle server.)
[$#8226] Discard file: Is a file that can be created, if necessary, to store all records that did not satisfy
the selection criteria
阅读(542) | 评论(0) | 转发(0) |