My Oracle Support Banner

Guidance Required Whether To Truncate The Mentioned DB Table (Doc ID 2769838.1)

Last updated on SEPTEMBER 24, 2023

Applies to:

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

Goal

Customer noticed a few blocks of corrupted DB and they want to truncate the tables:
OWNER SEGMENT TYPE SIZE_IN_GB
PROD_SOAINFRA AUDIT_TRAIL TABLE 2023
PROD_SOAINFRA CUBE_SCOPE TABLE 116
PROD_SOAINFRA CUBE_INSTANCE TABLE 63
PROD_SOAINFRA SCA_FLOW_INSTANCE TABLE 18
PROD_SOAINFRA AT_CIKEY INDEX 39
 

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!


In this Document
Goal
Solution
References


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