Vector 6.3 | 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: 12/06/2024