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.

It includes the following topic:

• Repository Creation Utility Schemas, IDs, and Tablespaces

B.1 Repository Creation Utility Schemas, IDs, and Tablespaces

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
AS Common Schemas
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
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)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 (UMS) 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 (UMS) 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)
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)
Analytics	ACTIVITIES	ACTIVITIES	IAS_ACTIVITY	IAS_TEMP	Oracle Platform Security Services (OPSS) Audit Services (IAU) Audit Services Append (IAU_APPEND) Audit Services Viewer (IAU_VIEWER)
Discussions	DISCUSSIONS	DISCUSSIONS	IAS_DISCUSS	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	None
Oracle WebCenter Content Server — Complete	OCS	CONTENT	OCS	OCS_TEMP	Oracle Platform Security Services (OPSS) Audit Services (IAU) Audit Services Append (IAU_APPEND) Audit Services Viewer (IAU_VIEWER)
Oracle WebCenter Enterprise Capture	CAPTURE	CAPTURE	CAPTURE	CAPTURE_TEMP	Metadata Services (MDS) Oracle Platform Security Services (OPSS) Audit Services (IAU) Audit Services Append (IAU_APPEND) Audit Services Viewer (IAU_VIEWER)
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 GoldenGate
Monitor Server	OGGMON	OGGMON	OGGMON	IAS_TEMP	Oracle Platform Security Services (OPSS) Audit Services (IAU) Audit Services Append (IAU_APPEND) Audit Services Viewer (IAU_VIEWER)
Veridata Repository	VERIDATA	VERIDATA	VERIDATA_USER	VERIDATA_TEMP	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 (EDQCONFIG)
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 (EDQCONFIG) EDQ Results Repository (EDQRESULTS)

¹

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