Installation Guide for Oracle Database with IBM WebSphere

Back Next

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.

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;

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;