Creating Repository Storage Spaces

1. Supported Database Engines:
• Oracle Data Integrator repositories can be installed on database engines supported by Oracle Fusion Middleware 12c.
• For the latest list of supported database versions and requirements, refer to the Oracle Fusion Certification.
2. Storage Space Requirements:
• A storage space must be created for each database that will contain a repository.
3. Caution - Separate Repositories from Application Data:
• For maintenance and backup reasons, Oracle strongly recommends storing repositories separately from your application data.
• This can mean storing repositories in a different schema (for Oracle databases) or a different database (for Microsoft SQL Server).
4. Master and Work Repositories in the Same Schema:
• Master repository can be stored in the same schema as a work repository.
• However, you cannot create two different work repositories in the same schema.
5. Example for Oracle:
• To create schemas for the master and work repositories in Oracle, use the following steps:

Steps for Schema Creation:

• Create the master repository schema (odim) and work repository schema (odiw).

SQL Commands to create schemas:

SQL> create user MY_SCHEMA identified by MY_PASS

      default tablespace MY_TBS

      temporary tablespace MY_TEMP;

SQL> grant connect, resource to MY_SCHEMA;

SQL> grant execute on dbms_lock to MY_SCHEMA;

• Where:
• MY_SCHEMA: Name of the schema to create (e.g., odim, odiw).
• MY_PASS: Password for the schema.
• MY_TBS: Oracle tablespace where data will be stored.
• MY_TEMP: Temporary default tablespace for the schema.