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.