2.3.4 Create Sandbox Schema

This section describes how to create the Sandbox schema.

Note:

  • This section is applicable to all use cases with the exception of ASC. For ASC, the sandbox should be a valid prod-parallel BD schema.
  • The Sandbox schema will always reside in a different database than the Atomic (BD/ECM) schema database.
  • After creating a user for the sandbox schema, you must create a sandbox workspace.
  • The tablespace and quota sizes should be defined based on the size of the data.
To create a sandbox schema, create a new Oracle Database sandbox schema user using the following script: 
create user <SANDBOX SCHEMA USER>
IDENTIFIED BY <PASSWORD>
default tablespace AIF_USER_TS
temporary tablespace TEMP
profile DEFAULT
quota unlimited on AIF_USER_TS
quota unlimited on AIF_USER_TEMP_TS

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