Truncating a Log that Is Not on A Separate Segment

If a database does not have a log segment on a device that is separate from data segments, you cannot use dump transaction to copy the log and then truncate it.

  1. Use the special with truncate_only option of dump transaction to truncate the log so that it does not run out of space. Because it does not copy any data, with truncate_only requires only the name of the database.
  2. Use dump database to copy the entire database, including the log.

This example dumps the database mydb, which does not have a log segment on a separate device from data segments, and then truncates the log:

dump database mydb to mydevice
dump transaction mydb with truncate_only
Parent topic: Transaction Log Space Management