D Metadata Repository Schemas

Oracle Fusion Middleware components store metadata in a repository. Many components require a database repository to store schemas to support the component. This appendix provides information about those schemas.

This appendix contains the following topics:

Metadata Repository Schema Descriptions
Metadata Repository Schemas, Tablespaces, and Data Files

D.1 Metadata Repository Schema Descriptions

Table D-1 lists the schemas used by Oracle Fusion Middleware components, sorted alphabetically by component. Note that the schema names are prefixed by the prefix you supplied when you ran the Repository Creation Utility.

Table D-1 Metadata Schemas Created by Repository Creation Utility

Component	Schema	Description
Oracle Access Manager	OAM	Contains information for Oracle Access Manager.
Oracle Adaptive Access Manager	OAAM OAAM_PARTN	Contains information for Oracle Adaptive Access Manager.
Oracle B2B	SOAINFRA	Contains the design and run-time repository. The design repository has modeling metadata and profile data for an integration. These describe the behavior of the integration and sequence of steps required to execute the business process. The modeling and profile metadata is the design of the integration prior to deployment and execution. Once the integration is deployed, the run-time repository contains the metadata required to execute the integration as well as the business process instance, event instances, role instances, and other data created during execution.
Oracle BPEL Process Manager	MDS SOAINFRA	MDS contains process definitions and configuration information. SOAINFRA contains instance and metadata database objects for Oracle Business Activity Monitoring and Oracle BPEL Process Manager.
Oracle Business Activity Monitoring	ORABAM MDS	Contains instance and metadata database objects for Oracle Business Activity Monitoring.
Oracle Business Intelligence	BISERVER BISCHEDULER BISCORECARD BIPUBLISHER	Contains metadata for Business Intelligence Server.
Oracle Business Intelligence Discoverer	DISCOVERER DISCOVERER_PS	Contains metadata for Discoverer Portlet Provider, portlet definitions for user portlets, and cached data obtained by running scheduled Discoverer queries. Has `RESOURCE` and `CONNECT` privileges.
Oracle Business Process Management	SOAINFRA	Contains metadata related to Oracle Business Process Management, as well as other SOA components.
Oracle Business Rules	MDS	Contains configuration information for Oracle Business Rules.
Oracle Content Server	OCS	Contains metadata information for Oracle Content Server 11g.
Oracle Data Integrator	ODI_REPO	Contains information for Oracle Data Integrator
Oracle Deployment Server	ODSSERVER	Contains metadata information for Oracle Deployment Server.
Oracle Directory Integration Platform	ODSSM	Contains configuration data for Oracle Directory Integration Platform.
Oracle Event Processing	MDS	MDS stores .MAR files, which store Oracle Event Processing .cqlsx files
Oracle Identity Federation	OIF	Contains metadata for Oracle Identity Federation.
Oracle Identity Manager	OIM	Contains metadata for applications that use Oracle Identity Manager.
Oracle Imaging and Process Management	I PM	Contains metadata for Oracle Imaging and Process Management.
Oracle Information Rights Management	ORAIRM	Contains metadata for Oracle Information Rights Management.
Oracle Internet Directory	ODS ODSSM	For internal use.
Oracle Mediator	MDS SOAINFRA	Contains metadata for Oracle Mediator.
Oracle Metadata Service	MDS	Contains metadata for applications that use MDS.
Oracle Portal	PORTAL	Contains Oracle Portal database objects and code.
Oracle Real-Time Decisions	RTD	For internal use.
Oracle Single Sign-On	ORASSO	For internal use.
Oracle SOA Suite Infrastructure	SOAINFRA	Contains metadata related to Oracle B2B, Oracle BPEL Process Manager, Oracle Business Process Management, Workflow, Sensor, Mediator, and CEP.
Oracle Universal Content Management	OCS OCSSEARCH	Contains metadata for Oracle Universal Content Management.
Oracle Universal Records Management	URMSERVER	Contains metadata for Oracle Universal Records Management
Oracle User Messaging	ORASDPM	Contains metadata related to User Messaging.
Oracle Web Services Manager	MDS	Contains configuration information.
Oracle WebCenter	WEBCENTER MDS	Contains information for Oracle WebCenter.
Oracle WebCenter Discussions	DISCUSSIONS DISCUSSIONS_CRAWLER	Contains information for WebCenter Discussions.
Oracle WebCenter Portlets	PORTLET	Contains information for WebCenter Portlet Producers.
Oracle WebCenter Spaces	WEBCENTER MDS	Contains information for WebCenter Services Links, Lists, Tags, and Events.
Oracle WebCenter Wiki and Blog Server	WIKI	Contains information for WebCenter Wiki and Blogs Server.

D.2 Metadata Repository Schemas, Tablespaces, and Data Files

Table D-2 lists the tablespace and default data file for each Metadata Repository schema. It is sorted alphabetically by schema name. Note that the default data files are prefixed by the prefix you assigned the schemas in RCU.

In addition to the tablespaces listed, the tablespace IAS_TEMP is always created when you create a schema with RCU. Its data file is iastemp.dbf.

Table D-2 Metadata Repository Tablespaces and Data Files

Schema	Tablespace	Default Data File
OAM	OAM	oam.dbf
BIPUBLISHER	BIPUBLISHER	BIPUBLISHER.dbf
BISCHEDULER	BISCHEDULER	bischeduler.dbf
BISCORECARD	BISCORECARD	biscorecard.dbf
BISERVER	BISERVER	biserver.dbf
DISCOVERER	DISCO_PTM5_META DISCO_PTMS_CACHE DISCO_PSTORE	discoptm5meta.dbf discoptm5cache.dbf discopstore.dbf
DISCUSSIONS	IAS_DISCUSS	iasjive.dbf
DISCUSSIONS_CRAWLER	IAS_DSCRAWL	iasjivecrawl.dbf
IPM	IPM	ipm.dbf
MDS	MDS	iasmds.dbf
OAAM	BRSADATA	brsdatan.dbf
OAAM_PARTN	OAAM_DATA	partn_brsadatan.dbf
OAM	OAM	oam.dbf
OCS	OCS	ocs.dbf
OCSSEARCH	OCSSEARCH	ocssearch.dbf
ODI_REPO	ODI_USER	prefix_odi_user_n.dbf
ODS	OLTS_DEFAULT	default1_oid.dbf
ODSERVER	ODSERVER	odserver.dbf
ODSSM	ODSSM	odssm.dbf
OIF	IAS_OIF	iasoif.dbf
OIM	OIM	oim.dbf
ORABAM	ORABAM	orabam.dbf
ORAIRM	ORAIRM	orairm.dbf
ORASDPLS	IAS_ORASDPLS	orasdpls.dbf
ORASDPM	IAS_ORASDPM IAS_ORASDPM_AQ	iassdpm.dbf iassdpmaq.dbf
ORASDPSDS	IAS_ORASDPSDS	orasdpsds.dbf
ORASDPSXDMS	IAS_ORASDPSXDMS	orasdpsxdms.dbf
ORASSO	IAS_ORASSO	iasorasso.dbf
PORTAL	PORTAL PORTAL_IDX PORTAL_LOG PORTAL_DOC	portal.dbf portalidx.dbf portallog.dbf portaldoc.dbf
PORTLET	IAS_PORTLET	webcenter_portlet.dbf
RTD	IAS_RTD	iasrtd.dbf
SOAINFRA	SOAINFRA	soainfra.dbf
URMSERVER	URMSERVER	urmserver.dbf
WEBCENTER	IAS_WEBCENTER	iaswebcenter.dbf
WIKI	IAS_WIKI	iaswiki.dbf