Deploy Metadata for Oracle Database

Become familiar with the Oracle Database and its tools before attempting to deploy metadata in the Oracle Database.

See SQL Access Advisor in Oracle Database Performance Tuning Guide.

Ensure that you complete the steps in Run the Generator before deploying metadata. To deploy cube metadata, perform the tasks described in the following sections:

• Run the SQL File for Oracle Database

• Define Constraints for the Existence of Joins

• Create the Query Workload

• Create Materialized Views