5. Populating Tables : Large Data Loads with the Set Nologging Statement
 
Share this page                  
Large Data Loads with the Set Nologging Statement
The SET NOLOGGING statement allows you to bypass the logging and recovery system. This can be time-efficient for certain types of batch update operations but must always be used with extreme care. An update failure of any sort while NOLOGGING is set will mark the entire database inconsistent, and render it inaccessible.
The SET NOLOGGING statement is intended to be used solely for large database load operations for which the reduction of logging overhead and log file space usage outweigh the benefits of having the system recover automatically from update errors.