My Oracle Support Banner

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

To view full details, 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 a vibrant support community of peers and Oracle experts.