Disabling Journal Files

Go Up to Enabling Journaling and Creating Journal Files

The DROP JOURNAL statement discontinues the use of write-ahead logging and deletes all journal files. This operation does not delete any journal files in the journal archive but does discontinue maintenance of the journal archive. Dropping journal files requires exclusive access to the database.

To disable journaling, use the following syntax:

DROP JOURNAL