-
Hi,
I'm using SQLLoader to insert the data in Oracle. Some times it is skipping the first record. Suppose that there are 10 files we are loading in... on some days it loads the data fine and sometimes in some files it skips the first record. Can i know the reason behind this ?
Thanks
Ramesh
-
sqlldr will tell you the reason it rejects the record with an error in the log file. The record that gets rejected will get thrown to the file specified by the discard= flag.
Jeff Hunter
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|