Upgrading from Version 9.0.1 or 9.1.0 for Oracle

Back Next

Creating Tablespaces on Premises

If you use Oracle on premises, create tablespaces as permanent tablespaces that you manage locally or configure manually.

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 NOLOGGING DATAFILE '<Oracle install directory>/CMX_DATA1.dbf' SIZE 2048M REUSE EXTENT MANAGEMENT LOCAL; Do not change the default tablespace name to prevent Repository Manager validation errors.
CMX_INDX	CREATE BIGFILE TABLESPACE CMX_INDX NOLOGGING DATAFILE '<Oracle install directory>/CMX_INDX1.dbf' SIZE 2048M REUSE EXTENT MANAGEMENT LOCAL;
CMX_TEMP	CREATE BIGFILE TABLESPACE CMX_TEMP NOLOGGING DATAFILE '<Oracle install directory>/CMX_TEMP1.dbf' SIZE 2048M REUSE EXTENT MANAGEMENT LOCAL;

Default Tablespace Name

Sample SQL Statement

CMX_DATA

CREATE BIGFILE TABLESPACE CMX_DATA
NOLOGGING
DATAFILE '<Oracle install directory>/CMX_DATA1.dbf' SIZE 2048M REUSE
EXTENT MANAGEMENT LOCAL;

Do not change the default tablespace name to prevent

Repository Manager

validation errors.

CMX_INDX

CREATE BIGFILE TABLESPACE CMX_INDX
NOLOGGING
DATAFILE '<Oracle install directory>/CMX_INDX1.dbf' SIZE 2048M REUSE EXTENT MANAGEMENT LOCAL;

CMX_TEMP

CREATE BIGFILE TABLESPACE CMX_TEMP
NOLOGGING
DATAFILE '<Oracle install directory>/CMX_TEMP1.dbf' SIZE 2048M REUSE EXTENT MANAGEMENT LOCAL;