Use a SQL Statement to Add a View Composer Database to an Oracle Instance

When you create the database, you can customize the location of the data and log files.

Prerequisites

The View Composer database must have certain table spaces and privileges. You can use a SQL statement to create the View Composer database in an Oracle 12c or 11g database instance.

Verify that a supported version of Oracle 12c or 11g is installed on the local or remote computer. For details, see Database Requirements for View Composer and the Events Database.

Procedure

Log in to a SQL*Plus session with the system account.
Run the following SQL statement to create the database.
```
CREATE SMALLFILE TABLESPACE "VCMP" DATAFILE '/u01/app/oracle/oradata/vcdb/vcmp01.dbf'
SIZE 512M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT
SPACE MANAGEMENT AUTO;
```
In this example, VCMP is the sample name of the View Composer database and vcmp01.dbf is the name of the database file.

For a Windows installation, use Windows conventions in the directory path to the vcmp01.dbf file.

What to do next

If you want to run the View Composer database with specific security permissions, follow the instructions in Configure an Oracle Database User for View Composer.

Follow the instructions in Add an ODBC Data Source to Oracle 12c or 11g