Tuesday, March 22, 2011

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)


Ahmed Aboulnaga

2 comments:

reamon said...

Do you know if the underlying tables are different between 11.1.1.3 and 11.1.1.4?

Viagra Online said...

This is perfect because it's incredible when we can get versions like those in order to simplify our lives, it has been excellent for me when I'm working at home.