3. Using Alternate Locations : Locations and Areas : Guidelines for Using Locations
 
Share this page                  
Guidelines for Using Locations
After you have set up the underlying area and mapped it to a location by creating a location object, use the new location as summarized below:
When you create a new database, specify the location for the database’s data dump, checkpoint, journal, and work files.
Extend a database to include the new location for its data and work files.
After extending a database to use an alternate location designated for data files, move existing user data files (that is, user tables and indexes, but not the system catalogs) to it, and place new user data files in it. For more information, see the chapter “Managing Tables and Views.”
The following file types can use only a single location (that is, these file types are not affected when you extend a database):
Checkpoint files
Journal files
Dump files
The initial location of the following file types is determined when you create a database, but you can move each to a new location (see page Relocate Database Files) if the need arises:
Checkpoint files
Journal files
Dump files
Store the data, checkpoint, journal, dump, and work files for a database in the same locations or in different locations.
If the default locations are used when you create the database, all these files are stored in the same area.
We strongly recommend that you store data files on a different disk from those used to store checkpoints, journals, and dumps. Doing so helps to protect your data in the event of disk failure and to maximize disk drive performance.
The following table summarizes some of these guidelines:
File Type
Extend to Use Multiple Locations?
Change Locations?
Data
Yes
Yes (user tables and indexes)
No (system catalogs)
Checkpoint
No
Yes
Journal
No
Yes
Dump
No
Yes
Work
Yes
No