You can move journal, checkpoint, and dump work files for an existing database to another location.

Locations must exist prior to this operation and must be specified with an appropriate Usage Type (that is, journal, checkpoint, or dump, depending on the type of file you want to relocate). When you relocate checkpoint, journal, or dump files, the existing files are moved to the new location and any new files are created there.

You can relocate database files using the relocatedb system command. For more information, see the Command Reference Guide.

You can also use the Alter Database dialog in VDBA. For more information, see the online help topic Altering a Database.

For example, the following command relocates the checkpoint location for the “empdata” database to “newckp”:

You can also use relocatedb to copy an entire database and move selected data locations. For more information, see Ways to Copy and Relocate a Database.