My Oracle Support Banner

How To Reclaim Space For Overgrown/Huge Footprint Of LOB Columns In OIM Database (Doc ID 2017034.1)

Last updated on JULY 21, 2020

Applies to:

Identity Manager - Version to [Release 11g]
Information in this document applies to any platform.


One can come often across scenarios where the snapshots(LOB) related data are either already very big in size or or is growing at very rapid rate in OIM. For example: the DB size is only 18GB but the Snapshot is 288GB and one would like to delete selective old snapshots from UPA table in order to get rid of snapshots that are not needed.

In these type of scenarios one can often see another issue of  "once we delete these rows the lob space being used is not turned into free space" and often ask "Please advise what is this best way to clear out this space once we delete rows in UPA  etc tables"

This article will advise on how to do the shrink operation to claim the free LOB space.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.