D Metadata Repository Schemas

Oracle Fusion Middleware components store metadata in a repository. Many components require a database repository to storeschemas 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 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 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 Business Intelligence	BISERVER BISCHEDULER BISCORECARD BIPUBLISHER	Contains metadata for Business Intelligence Server.
Oracle Business Rules	MDS	Contains configuration information for Oracle Business Rules.
Oracle Event Processing	MDS	.cqlsx files are stored in a .MAR file, which is stored in MDS.
Oracle Directory Integration Platform	ODSSM	Contains configuration data for Oracle Directory Integration Platform.
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 Mediator	MDS SOAINFRA	Contains metadata for Oracle Mediator.
Oracle Metadata Service	MDS	Contains metadata for applications that use MDS.
Oracle Identity Federation	OIF	Contains metadata for Oracle Identity Federation.
Oracle Internet Directory	ODS	For internal use.
Oracle Identity Manager	OIM	Contains metadata for applications that use Oracle Identity Manager.
Oracle Content Server	OCSERVER	Contains information for WebCenter Content Server.
Oracle Portal	PORTAL PORTAL_DEMO PORTAL_APP PORTAL_PUBLIC PORTAL_APPROVAL	Contains Oracle Portal database objects and code.
Oracle Single Sign-On	ORASSO	For internal use.
Oracle User Messaging	ORASDPM	Contains metadata related to User Messaging.
Oracle WebCenter Discussions	DISCUSSIONS	Contains information for WebCenter Discussion.
Oracle WebCenter Spaces	WEBCENTER MDS	Contains information for WebCenter Services Links, Lists, Tags, and Events.
SOA Infrastructure	SOAINFRA	Contains metadata related to Oracle B2B, Oracle BPEL Process Manager, Workflow, Sensor, Mediator, and CEP.
Oracle WebCenter Portlets	PORTLET	Contains information for WebCenter Portlet Producers.
Oracle WebCenter Wiki and Blog Server	WIKI	Contains information for WebCenter Wiki and Blogs Server.
Oracle Web Services Manager	MDS	Contains configuration information.

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
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_DISCUSSIONS	iasjive.dbf
IAU	IAS_IAU	ias_iau.dbf
OCSERVER	OCSERVER OCSERVER_TEMP	ocserver.dbf ocservertemp.dbf
IPM	IPM	ipm.dbf
MDS	MDS	iasmds.dbf
NS	IAS_NS IAS_NS_AQ	iasns.dbf iasnsaq.dbf
ODI_MASTER	ODI_MASTER	odi_master_01.dbf
ODI_EXEC_WORK	ODI_EXEC_WORK	odi_exec_work_01.dbf
ODI_DEV_WORK	ODI_DEV_WORK	odi_dev_work_01.dbf
ODS	OLTS_DEFAULT	default1_oid.dbf
OIM	OIM OIM_TEMP	oim.dbf oimtemp.dbf
ORABAM	ORABAM	orabam.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
SOAINFRA	SOAINFRA	soainfra.dbf
WEBCENTER	IAS_WEBCENTER	iaswebcenter.dbf
WIKI	IAS_WIKI	iaswiki.dbf