5. Populating Tables : Large Data Loads with the Set Nologging Statement : Suspend Transaction Logging
 
Share this page                  
Suspend Transaction Logging
To suspend transaction logging for the current session, issue the following statement:
SET NOLOGGING
This statement can be issued only by the DBA of the database on which the session is operating and cannot be issued while currently executing a multi-statement transaction.