Table of Contents

Search

  1. Preface
  2. Installation Overview
  3. Pre-Installation Tasks
  4. Hub Store Installation
  5. Hub Store Post-Installation Tasks
  6. Hub Server Installation
  7. Hub Server Post-Installation Tasks
  8. Process Server Installation
  9. Process Server Post-Installation Tasks
  10. ActiveVOS Post-Installation Tasks for the Application Server
  11. ActiveVOS Post-Installation Tasks for the Business Entity Adapter
  12. Resource Kit Installation
  13. Troubleshooting the MDM Hub
  14. Uninstallation

Installation Guide for Oracle Database with Red Hat JBoss

Installation Guide for Oracle Database with Red Hat JBoss

Creating Tablespaces in Amazon Relational Database Service

Creating Tablespaces in Amazon Relational Database Service

If you use Amazon Relational Database Service (RDS) for Oracle, create tablespaces as permanent tablespaces in Amazon RDS.
Create bigfile tablespaces to simplify database management for large data loads. However, you can create smallfile tablespaces if required.
  1. Log in to Amazon RDS for Oracle as a database administrative user.
  2. Create the tablespaces.
    The following table contains sample SQL statements to create tablespaces:
    Default Tablespace Name
    Sample SQL Statement
    CMX_DATA
    CREATE BIGFILE TABLESPACE CMX_DATA DATAFILE SIZE 2048M AUTOEXTEND ON NEXT 2048M;
    Do not change the default tablespace name to prevent
    Repository Manager
    validation errors.
    CMX_INDX
    CREATE BIGFILE TABLESPACE CMX_INDX DATAFILE SIZE 2048M AUTOEXTEND ON NEXT 2048M;
    CMX_TEMP
    CREATE BIGFILE TABLESPACE CMX_TEMP DATAFILE SIZE 2048M AUTOEXTEND ON NEXT 2048M;

0 COMMENTS

We’d like to hear from you!