We currently use Oracle SOA Suite for multiple projects. As part of Load Testing for one of the projects, we found that the SOA INFRA Tablespace got filled up to 32 GB in a day. We need a very effective Purge Stategy that would help us maintain the TableSpace for SOAINFRA.
Also we have multiple teams using Oracle SOA Suite. How would we differentiate between Teams as part of Purging Strategy. Lets say Team1's SOAINFRA specific data in Tablespaces need to be purged every 7 days and Team2's and Team3's SOAINFRA specific data in Tablespaces need to be purged every month. Can we achieve this.
Is there a way to do a wild card purge, lets say Team1's projects start with ABC_<projectname> and Team2's projects start with DEF_<projectname> and we can do different purging for ABC_* to purge every 7 days and DEF_* to purge every month.