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; To prevent Repository Manager validation errors, do not change the default tablespace name.
CMX_INDX	CREATE BIGFILE TABLESPACE CMX_INDX DATAFILE SIZE 2048M AUTOEXTEND ON NEXT 2048M; To prevent Repository Manager validation errors, do not change the default tablespace name.
CMX_TEMP	CREATE BIGFILE TABLESPACE CMX_TEMP DATAFILE SIZE 2048M AUTOEXTEND ON NEXT 2048M;