Can we have multiple files listed in one control file for loading into multiple tables(sql*loader)?
well I haven't done multiple, but I know in Oracle 9i you can, plus you always can declare a "BadRecords" table that takes the records that don't get loaded. It you have 50 default errors and that is what it is set to, yes it quits loading. Many first hand knowledge there. Mark
Joined: Jul 11, 2001
I know that sqlldr quits when it reaches the default errors in the bad file. But my question was about the bad file when we have multiple files in one control file for multiple tables(if at all it is possible). Does it wait till it finishes all the files or quit as soon as any of the bad file gets the 50 records. Thank you for your answer. We made the forum alive!! Beksy
Atif, I am creating a new thread for you question. This thread was only to get activity into this forum, so I doubt people will take the thread serious enough to get to the bottom and see you post, and I want you to get some responses back to help you. You will find the new post here. Mark [ June 10, 2002: Message edited by: Mark Spritzler ]