11. Using Alternate Locations : Create a Database in an Alternate Location
 
Share this page                  
Create a Database in an Alternate Location
You can create a database in a location other than II_DATABASE by using the ‑d flag on the createdb command. This location becomes the new default location for this database.
To create a database in a location other than the default
1. Create the location. For example:
CREATE LOCATION db_vw WITH AREA = '\disk2\vw_extra', USAGE = DATABASE;
2. Issue a createdb command. For example:
createdb inventory -ddb_vw
In this example, the inventory database is created in a new default location db_vw. The location was defined previously with CREATE LOCATION statement. The checkpoint files for the database are created in II_CHECKPOINT because no checkpoint location was specified.