SQL Language Guide : 8. SQL Statements : ALTER LOCATION : ALTER LOCATION Examples
 
Share this page                  
ALTER LOCATION Examples
The following examples change the type of files that can be created at an existing location:
1. Specify that only checkpoint files can be created at the checkpoint_disk location.
ALTER LOCATION checkpoint_disk
   WITH USAGE = (CHECKPOINT);
2. Prevent any files from being created at the new_db location.
ALTER LOCATION new_db WITH NOUSAGE;