SOAINFRA Sensor Tables VARIABLE_SENSOR_VALUES, ACTIVITY_SENSOR_VALUES, COMPOSITE_SENSOR_VALUE, FAULT_SENSOR_VALUES are not Purged of Data After Running SOA Purge Scripts
Last updated on NOVEMBER 03, 2016
Applies to:Oracle SOA Platform - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
***Checked for relevance on 13-Dec-2012***
You have purged SOA instance data by following this documentation:
Oracle® Fusion Middleware Administrator's Guide for Oracle SOA Suite and Oracle Business Process Management Suite
11g Release 1 (22.214.171.124.0)
Part Number E10226-09
Section: 9.3 Deleting Large Numbers of Instances with the Purge Scripts
After the purge it is noticed that the SOAINFRA Tables VARIABLE_SENSOR_VALUES, ACTIVITY_SENSOR_VALUES, COMPOSITE_SENSOR_VALUE, FAULT_SENSOR_VALUES have not been purged of any data. There may be many rows in these tables depending on the usage of Sensors.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms