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 11g or 10g database instance.
Verify that a supported version of Oracle 11g or 10g is installed on the vCenter Server computer. For details, see Database Requirements for View Composer.
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 11g or 10g