Ingres 11.2 | CREATE LOCATION Examples

Was this helpful?

CREATE LOCATION Examples

UNIX:

Create a location using a UNIX path.

CREATE LOCATION extraloc

WITH AREA = '/usr/ingres_extra',

USAGE = (JOURNAL, CHECKPOINT);

VMS:

Create a new location for databases; allow all types of files to be stored.

CREATE LOCATION accounting_db WITH AREA = 'disk1:',

USAGE = (ALL);

Create a new location, but prevent any files from being created there.

CREATE LOCATION new_db WITH AREA = 'disk2:',

NOUSAGE;

Last modified date: 08/28/2024