About Repository Creation Utility Schemas, IDs, and Tablespaces

B About Repository Creation Utility Schemas, IDs, and Tablespaces

Before you run RCU, make sure you understand the available schemas that can be created by using RCU, and also their component IDs and dependencies.

Following sections explains about the RCU schemas and its dependencies:

Repository Creation Utility Schemas, IDs, and Tablespaces
Each schema that can be created by using RCU has a schema owner, component ID, and default tablespace mappings. You should also be aware of schema dependencies when you create or drop schemas.

Repository Creation Utility Schemas, IDs, and Tablespaces

Each schema that can be created by using RCU has a schema owner, component ID, and default tablespace mappings. You should also be aware of schema dependencies when you create or drop schemas.

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 see in RCU, and is also the name that you must provide in the Oracle Fusion Middleware Configuration Wizard on the JDBC Component Schema screen, prepended by the custom prefix.

The Component ID is the value that you must specify with the -component parameter when you create or drop schemas from the command line.

Note:

Not all schemas are supported on all database types. For more information about supported schemas, see Repository Creation Utility Requirements 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
AS Common Schemas
Metadata Services	`MDS`	`MDS`	`MDS`	`IAS_TEMP`	None
Audit Services	`IAU`	`IAU`	`IAU`	`IAS_TEMP`	Audit Services Append (`IAU_APPEND`) Audit Services Viewer (`IAU_VIEWER`)
Audit Services Append	`IAU_APPEND`	`IAU_APPEND`	`IAU`	`IAS_TEMP`	None
Audit Services Viewer	`IAU_VIEWER`	`IAU_VIEWER`	`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
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
Oracle Data Integrator
Master and Work Repository	`ODI_REPO`	`ODI`	`ODI_USER`	`ODI_TEMP`
SOA Suite
SOA Infrastructure	`SOAINFRA`	`SOAINFRA`	`SOAINFRA`	`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 (`UCSUMS`) WebLogic Services (`WLS`)
Managed File Transfer
Managed File Transfer	`MFT`	`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 (`UCSUMS`) Oracle Enterprise Scheduler (`ESS`)
Oracle Business Intelligence
Business Intelligence Platform	`BIPLATFORM`	`BIPLATFORM`	`BIPLATFORM`	`IAS_TEMP`	Metadata Services (`MDS`) Oracle Platform Security Services (`OPSS`) Audit Services (`IAU`) Audit Services Append (`IAU_APPEND`) Audit Services Viewer (`IAU_VIEWER`) WebLogic Services (`WLS`)
WebCenter Portal
Portal and Services	`WEBCENTER`	`WEBCENTER`	`IAS_WEBCENTER`	`IAS_TEMP`	Metadata Services (`MDS`) Oracle Platform Security Services (`OPSS`) Audit Services (`IAU`) Audit Services Append (`IAU_APPEND`) Audit Services Viewer (`IAU_VIEWER`)
Portlet Producers	`PORTLET`	`PORTLET`	`IAS_PORTLET`	`IAS_TEMP`	Oracle Platform Security Services (`OPSS`) Audit Services (`IAU`) Audit Services Append (`IAU_APPEND`) Audit Services Viewer (`IAU_VIEWER`)
WebCenter Content
Oracle WebCenter Content Server — Search Only	`OCSSEARCH`	`CONTENTSEARCH`	`OCSSEARCH`	`OCSSEARCH_TEMP`	Common Infrastructure Services (`STB`) WebLogic Services (`WLS`)
Oracle WebCenter Content Server — Complete	`OCS`	`CONTENT`	`OCS`	`OCS_TEMP`	Common Infrastructure Services (`STB`) Oracle Platform Security Services (`OPSS`) Audit Services (`IAU`) Audit Services Append (`IAU_APPEND`) Audit Services Viewer (`IAU_VIEWER`) WebLogic Services (`WLS`)
Oracle WebCenter Enterprise Capture	`CAPTURE`	`CAPTURE`	`CAPTURE`	`CAPTURE_TEMP`	Common Infrastructure Services (`STB`) Metadata Services (`MDS`) Oracle Platform Security Services (`OPSS`) Audit Services (`IAU`) Audit Services Append (`IAU_APPEND`) Audit Services Viewer (`IAU_VIEWER`) WebLogic Services (`WLS`)
WebCenter Sites
WebCenter Sites	`WCSITES`	`WCSITES`	`TS_WCSITES`	`TS_TMP_WCSITES`	Oracle Platform Security Services (`OPSS`) Audit Services (`IAU`) Audit Services Append (`IAU_APPEND`) Audit Services Viewer (`IAU_VIEWER`)
WebCenter Sites — Visitor Services	`WCSITES_VS`	`WCSITESVS`	`TS_WCSITES_VS`	`TS_TMP_WCSITES_VS`	Oracle Platform Security Services (`OPSS`) Audit Services (`IAU`) Audit Services Append (`IAU_APPEND`) Audit Services Viewer (`IAU_VIEWER`)
Oracle Enterprise Data Quality (EDQ)
EDQ Config Repository	`EDQCONFIG`	`EDQ_CONF`	`EDQ_CONF`	`EDQ_CONFTEMP`	Oracle Platform Security Services (`OPSS`) Audit Services (`IAU`) Audit Services Append (`IAU_APPEND`) Audit Services Viewer (`IAU_VIEWER`)
EDQ Results Repository	`EDQRESULTS`	`EDQ_RES`	`EDQ_RES`	`EDQ_RESTEMP`	Oracle Platform Security Services (`OPSS`) Audit Services (`IAU`) Audit Services Append (`IAU_APPEND`) Audit Services Viewer (`IAU_VIEWER`) EDQ Config Repository (`EDQ_CONF`)
EDQ Staging Repository	`EDQSTAGING`	`EDQ_STAGING`	`EDQ_STAGING`	`EDQ_STAGINGTEMP`	Oracle Platform Security Services (`OPSS`) Audit Services (`IAU`) Audit Services Append (`IAU_APPEND`) Audit Services Viewer (`IAU_VIEWER`) EDQ Config Repository (`EDQ_CONF`) EDQ Results Repository (`EDQ_RES`)
Oracle Access Manager (OAM)
Oracle Access Manager	`OAM`	`OAM`	`OAM`	`OAM_TEMP`	Common Infrastructure Services (`STB`) Metadata Services (`MDS`) Oracle Platform Security Services (`OPSS`) Audit Services (`IAU`) Audit Services Append (`IAU_APPEND`) Audit Services Viewer (`IAU_VIEWER`) WebLogic Services (`WLS`)

^Footnote 1

For more information about the Service Table schema, see About the Service Table Schema.

As an example, Table B-2 provides the schema details for Oracle HTTP Server configuration.

Table B-2 Schemas for Oracle HTTP Server Configured in WebLogic Server Domain

Component Schema	Schema Owner
LocalSvcTbl Schema	`STB`
WLS Schema	`WLS_RUNTIME`
OPSS Audit Schema	`IAU_APPEND`
OPSS Audit Viewer Schema	`IAU_VIEWER`
OPSS Schema	`OPSS`

Parent topic: About Repository Creation Utility Schemas, IDs, and Tablespaces