SQL Reference Guide > SQL Reference Guide > SQL Statements > ALTER LOCATION > ALTER LOCATION Examples
Was this helpful?
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;
Last modified date: 08/29/2024