SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Loading SQL*Loader bad records into table

user637544Apr 2 2009 — edited Apr 5 2009

I m using 10g. I am creating my SQL*Loader control file on the fly. after executing the control file some bad records are created. I need to insert these bad records into another table. One column of the table will have the bad record [datatype LONG] and the other will have the file name. Can this be done through DML error logging or External table. I have multiple bad files.

This post has been answered by OrionNet on Apr 5 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 3 2009

Added on Apr 2 2009

16 comments

1,258 views