2.3.1 Create Tablespace

Tablespace is required to manage and allocate space for its database objects efficiently. It plays crucial role in efficient database management, performance optimization, and scalability which are essential for the effective functioning of Compliance Studio.

To create a tablespace in the Oracle Database use the scripts as described in the following table.

Table 2-5 Create Tablespace

User Script
AIF_USER_TEMP_TS CREATE TABLESPACE AIF_USER_TEMP_TS DATAFILE '<Datafile Path>' SIZE <size in byte> REUSE AUTOEXTEND ON NEXT <size in megabyte> MAXSIZE UNLIMITED;
AIF_USER_TS CREATE TABLESPACE AIF_USER_TS DATAFILE '<Datafile Path>' SIZE <size in byte> REUSE AUTOEXTEND ON NEXT <size in megabyte> MAXSIZE UNLIMITED;
<STUDIO TABLESPACE> CREATE TABLESPACE <STUDIO TABLESPACE> DATAFILE '<Datafile Path>' SIZE <size in byte> REUSE AUTOEXTEND ON NEXT <size in megabyte> MAXSIZE UNLIMITED;
<GRAPH_SCHEMA_TS> CREATE TABLESPACE <GRAPH_SCHEMA_TS> DATAFILE '<Datafile Path>' SIZE <size in byte> REUSE AUTOEXTEND ON NEXT <size in megabyte> MAXSIZE UNLIMITED;

Note:

  • The tablespace size should be defined based on the size of the data.
  • AIF_USER_TS and AIF_USER_TEMP_TS tablespaces are required in all Production and Sandbox databases.

Verify the AIF_USER_TS and AIF_USER_TEMP_TS are available in the BD production database server. If not, then you need to create a tablespace. After creating a tablespace, you need to provide a quota on the tablespace AIF_USER_TS and AIF_USER_TEMP_TS.

For example:

ALTER USER <BD ATOMIC SCHEMA USER> QUOTA <size in megabyte> ON AIF_USER_TS; ALTER USER <BD ATOMIC SCHEMA USER> QUOTA <size in megabyte> ON AIF_USER_TEMP_TS;