开发者

how to increase the limit of exceptions in oracle SQLLDR

开发者 https://www.devze.com 2022-12-29 07:10 出处:网络
how to increase the limit of exceptions in oracle ? i have a excel sheet in which their are about 900 records to be appended .so i converted the excel to dat file and wrote a batch file that read fro

how to increase the limit of exceptions in oracle ?

i have a excel sheet in which their are about 900 records to be appended .so i converted the excel to dat file and wrote a batch file that read from the dat file and appends it to the concern table but the batch file stop execution once the exceptions reach 51(all integrity constrain parent key not found) so the remaining valid files are not updated .its very difficult to find which record has integrity constrain is there a w开发者_StackOverflow社区ay to increase this exception limit ?


Specify the ERRORS SQLLDR command line parameter.

0

精彩评论

暂无评论...
验证码 换一张
取 消