How To Purge Metadata Version History For Unified Inventory Management? (Doc ID 1506469.1)

Last updated on APRIL 13, 2016

Applies to:

Oracle Communications Unified Inventory Management - Version 7.2.0 and later
Information in this document applies to any platform.
checked currency **29-Oct-2014**

Goal

A metadata repository contains metadata for Oracle Fusion Middleware components, such as Oracle BPEL Process Manager, Oracle B2B, and Oracle WebCenter Portal. It can also contain metadata about the configuration of Oracle Fusion Middleware and metadata for your applications i.e. Unified Inventory Management.

A particular type of data-based repository, the Oracle Metadata Services (MDS) Repository, contains metadata for UIM.
This repository is created using Oracle Fusion Middleware Metadata Repository Creation Utility (RCU), which is a prerequisite before installing UIM.
Click here for more details on Metadata repository.

As the MetaData Version history stored in UIM MetaData Repository (MDS) increases,  DEV_MDS.MDS_COMPONENTS table grows. As the DB runs out of space system Failes to allocate an extent of the required number of blocks for DEV_MDS.MDS_COMPONENTS table in the DEV_MDS tablespace. Users might see following error in Server / UIM logs:

<Warning> <oracle.mds> <MDS-10009> <The transfer of the document /oracle/communications/inventory/ui/place/page/mdssys/cust/dynamic/UIM_zone/PlaceEdit.jsff.xml is not successful.
oracle.mds.internal.persistence.db.fcf.MDSDBIOException: ORA-01653: unable to extend table DEV_MDS.MDS_COMPONENTS by 1024 in tablespace DEV_MDS

 
Through this document we explain 3 ways to purge UIM metadata version history.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms