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:

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

IPM

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