Installation

Table Of Contents
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
1 Log in to a SQL*Plus session with the system account.
2 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
Configure an Oracle Database User for View Composer
By default, the database user that runs the View Composer database has Oracle system administrator
permissions. To restrict the security permissions for the user that runs the View Composer database, you
must configure an Oracle database user with specific permissions.
Prerequisites
Verify that a View Composer database was created in an Oracle 12c or 11g instance.
Procedure
1 Log in to a SQL*Plus session with the system account.
View Installation
VMware, Inc. 48