Shrinking LOBs after SOA purging.

(Doc ID 2400236.1)

Last updated on JUNE 25, 2018

Applies to:

Oracle SOA Suite - Version 12.2.1.1.0 to 12.2.1.3.0 [Release 12c]
Information in this document applies to any platform.

Goal

To show an example reclaiming LOB Segment space after purging.

Disclaimer:
PROCEDURES TO RECLAIM SPACE AFTER PURGE MUST BE CREATED AND DONE BY AN EXPERIENCED DATABASE ADMINISTRATOR. Please engage your DBA for assistance on purge cleanup. Oracle consulting is another option. The below steps was done to provide an example that worked for one system.

 

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