ALTER LOCATION 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;