Can Only a Subset of SOAINFRA Tables Be Truncated to Reduce the Database Size?

(Doc ID 2399193.1)

Last updated on JUNE 29, 2018

Applies to:

Oracle SOA Suite - Version 11.1.1.9.0 and later
Information in this document applies to any platform.

Goal

Can we truncate only a subset of SOAINFRA tables to reduce the database size while retaining a years worth of history of the approval process requests that have gone through and the approvers, etc. (the information seen when looking at a request's Approval Details tab)?
 

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