What is the difference between Normal load and Bulk load?
Normal Load: Normal load will write information to the database log file so that if any recovery is needed it is will be helpful. When the source file is a text file and loading data to a table, in such cases we should you normal load only, else the session will be failed. Bulk Mode: Bulk load will not write information to the database log file so that if any recovery is needed we can’t do any thing in such cases.