Installation Guide for Oracle Database with Red Hat JBoss

10.5 HotFix 2

Back Next

Step 2. Create a Database and Tablespaces

After you install and configure Oracle Database, create and configure databases and tablespaces.

The following table describes the tasks that you need to perform to configure databases:

Tasks	Description
Create a database	Create a database for each database instance.
Create tablespaces	Create tablespaces for the MDM Hub data. Adjust the default tablespace sizes and the number of data files based on the volume of data that you want to load into the MDM Hub. Create the following tablespaces: CMX_DATA. Contains the metadata and user data of the MDM Hub. CMX_INDX. Contains indexes that the MDM Hub creates and uses. CMX_TEMP. Contains temporary tables for the MDM Hub. BPM_DATA. Contains the ActiveVOS data for business process management. If you want to create multiple MDM Hub Master Databases, create unique tablespaces for each MDM Hub Master Database.

Tasks

Description

Create a database

Create a database for each database instance.

Create tablespaces

Create tablespaces for the MDM Hub data. Adjust the default tablespace sizes and the number of data files based on the volume of data that you want to load into the MDM Hub.

Create the following tablespaces:

CMX_DATA. Contains the metadata and user data of the MDM Hub.

CMX_INDX. Contains indexes that the MDM Hub creates and uses.

CMX_TEMP. Contains temporary tables for the MDM Hub.

BPM_DATA. Contains the ActiveVOS data for business process management.

If you want to create multiple MDM Hub Master Databases, create unique tablespaces for each MDM Hub Master Database.

Set Up the Database Environment

Creating Tablespaces on Premises

Creating Tablespaces in Amazon Relational Database Service

Configuring the Database Environment for Custom Tablespace Names

Download Guide

Watch