5. Populating Tables : Large Data Loads with the Set Nologging Statement : Restore Transaction Logging
 
Share this page                  
Restore Transaction Logging
To resume logging, issue the following statement:
SET LOGGING
The SET LOGGING statement re-enables logging for a session for which the SET NOLOGGING statement was issued.
After SET LOGGING is executed, automatic database recovery is again guaranteed.
If you use SET NOLOGGING on a journaled database, take a new checkpoint immediately after completion of the SET LOGGING operations to establish a new base from which to journal updates.
When a session operation in SET NOLOGGING mode disconnects from a database, a SET LOGGING operation is implicitly executed to bring the database to a guaranteed consistent state before completing the disconnect.