10. Using Alternate Locations : Alter or Drop a Location
 
Share this page                  
Alter or Drop a Location
After a location is created, it can be altered or dropped. The ALTER LOCATION statement changes the type of files that can be created at an existing location.
To alter the location "invoix" in "area2" to allow usage as a work area only
ALTER LOCATION invoix WITH USAGE = (WORK);
Current use of the location is unaffected, but attempts to extend a database to the target location are constrained by the new usage setting.
To drop the location "duplicate"
DROP LOCATION DUPLICATE;
Note:  You can only drop a data or work location if no currently existing database has been extended to it. You cannot drop other types of locations.