SQL Language Guide > SQL Language Guide > SQL Statements > ALTER LOCATION > ALTER LOCATION Examples
Was this helpful?
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;
Last modified date: 11/09/2022