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.
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;