2.3.2 Create Studio Schema

The studio schema stores all the metadata information related to Compliance Studio.

Note:

The Compliance Studio schema and Atomic (BD/ECM) schema should be in the same database.

To create a studio schema, create a new Oracle Database schema user using the following script:

CREATE USER <STUDIO SCHEMA USER> IDENTIFIED BY <PASSWORD> DEFAULT TABLESPACE <STUDIO TABLESPACE>;
ALTER USER <STUDIO SCHEMA USER> QUOTA 2000M ON <STUDIO TABLESPACE>;
ALTER USER <STUDIO SCHEMA USER> QUOTA <SIZE IN MEGABYTE> ON AIF_USER_TS;

For example:

ALTER USER CS812_USER QUOTA 500M ON AIF_USER_TS;

Note:

The tablespace and quota sizes should be defined based on the size of the data.

A new Oracle Database schema (Studio schema) is created.