InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What Is The Difference Between Normal Load And Bulk Load? |
|
Answer» 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. comparatively Bulk load is pretty faster than normal 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. comparatively Bulk load is pretty faster than normal load. |
|