8. SQL Statements : CREATE LOCATION : CREATE LOCATION Examples
 
Share this page                  
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;