B Understanding Repository Creation Utility Schemas, IDs, and Tablespaces

This appendix lists the available schemas that can be created using RCU, and also their component IDs and dependencies.

Table B-1 lists the schemas along with their component IDs, tablespace mappings, and dependencies.

The "Schema Owner" is the name of the schema that you will see in RCU and is also the name you must provide in the Oracle Fusion Middleware Configuration Wizard on the Configure JDBC Component Schema screen, prepended by the custom prefix.

The "Component ID" is the value you must specify with the -component parameter when you are creating or dropping schemas using the command line.

Note:

Not all schemas are supported on all database types. For more information, refer to "Verifying Requirements for Repository Creation Utility" in the Oracle Fusion Middleware System Requirements and Specifications document.

Table B-1 Schema Component IDs, Tablespace Mappings, and Dependencies

Component Schema Owner Component ID Default Tablespace Temp Tablespace Dependencies

Metadata Services

MDS

MDS

MDS

IAS_TEMP

None

Audit Services

IAU

IAU

IAS_IAU

IAS_TEMP

Audit Services Append (IAU_APPEND)

Audit Services Viewer (IAU_VIEWER)

Audit Services Append

IAU_APPEND

IAU_APPEND

IAS_IAU

IAS_TEMP

None

Audit Services Viewer

IAU_VIEWER

IAU_VIEWER

IAS_IAU

IAS_TEMP

None

Oracle Platform Security Services

OPSS

OPSS

IAS_OPSS

IAS_TEMP

Audit Services (IAU)

Audit Services Append (IAU_APPEND)

Audit Services Viewer (IAU_VIEWER)

User Messaging Service

UMS

UCSUMS

IAS_UMS

IAS_TEMP

Metadata Services (MDS)

WebLogic Services

WLS

WLS

WLS

IAS_TEMP

None

Call Control

UCSCC

UCSCC

IAS_UCSCC

IAS_TEMP

Metadata Services (MDS)

Oracle Enterprise Scheduler

ESS

ESS

ESS

IAS_TEMP

Metadata Services (MDS)

Audit Services (IAU)

Audit Services Append (IAU_APPEND)

Audit Services Viewer (IAU_VIEWER)

Oracle Platform Security Services (OPSS)

Common Infrastructure Services (formerly Service Table)Foot 1 

STB

STB

STB

IAS_TEMP

None

Master and Work Repository

ODI

ODI

     

SOA Infrastructure

SOAINFRA

     

Metadata Services (MDS)

Audit Services (IAU)

Audit Services Append (IAU_APPEND)

Audit Services Viewer (IAU_VIEWER)

Oracle Platform Security Services (OPSS)

User Messaging Service (UMS)

WebLogic Services (WLS)

Managed File Transfer

MFT

 

MFT

IAS_TEMP

Metadata Services (MDS)

Audit Services (IAU)

Audit Services Append (IAU_APPEND)

Audit Services Viewer (IAU_VIEWER)

Oracle Platform Security Services (OPSS)

User Messaging Service (UMS)

Oracle Enterprise Scheduler (ESS)


Footnote 1 For more information about the Service Table schema, see Section 1.2.4.