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:

Tablespace Name	Sample SQL Statement
CMX_DATA	Do not change the default tablespace name to prevent Repository Manager validation errors. CREATE BIGFILE TABLESPACE CMX_DATA NOLOGGING DATAFILE '<Oracle install directory>/CMX_DATA1.dbf' SIZE 2048M REUSE EXTENT MANAGEMENT LOCAL;
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;
BPM_DATA	CREATE BIGFILE TABLESPACE BPM_DATA NOLOGGING DATAFILE '<Oracle install directory>/BPM_DATA1.dbf' SIZE 2048M REUSE EXTENT MANAGEMENT LOCAL;