Purging all composite instances in SOA Suite 11g

To purge all instances in Oracle SOA Suite 11g (11.1.1.4), simply run the following PL/SQL package. Note that the underlying table structure is slightly different in 11.1.1.2 versus 11.1.1.4, so these instructions are specific to 11.1.1.4, but may or may not work on older or later versions.

sqlplus dev_soainfra/welcome1@orcl

DECLARE
  FILTER INSTANCE_FILTER := INSTANCE_FILTER();
  DELETED_INSTANCES NUMBER;
BEGIN
  FILTER.MIN_CREATED_DATE := TO_TIMESTAMP('2001-01-01','YYYY-MM-DD');
  FILTER.MAX_CREATED_DATE := SYSDATE;
  DELETED_INSTANCES := FABRIC.DELETE_ALL(FILTER, 40000000, true);
END;
/

Applicable Versions:

• Oracle SOA Suite 11g (11.1.1.4)