Was this helpful?
CREATE LOCATION Examples
Create a location using a Linux path.
CREATE LOCATION extraloc
WITH AREA = '/usr/ingres_extra',
USAGE = (JOURNAL, CHECKPOINT);
Create a new location, but prevent any files from being created there.
CREATE LOCATION new_db WITH AREA = 'disk2:',
NOUSAGE;
Last modified date: 11/09/2022