11. Using Alternate Locations : Work Locations : Initial and Extended Work Locations
 
Share this page                  
Initial and Extended Work Locations
You specify the initial, or primary, location (or use the default location) for work files when you create a database. The area mapped to this location is used for all work files.
To use additional locations, extend a database. When you extend a database in this manner, sort space can be spread among multiple work locations.
Note:  We recommend that you put work locations on scratch disks so that sorting and spilling to disk activity does not contend with other database I/O and data disks do not become excessively fragmented.