Wednesday, February 24, 2010

Purge Script for SOA Suite 11g

You can find the purge script for SOA Suite 11g in the following location

rcuHome\rcu\integration\soainfra\sql\purge

The different script present there are

purge_bpel_oracle.sql

purge_common_oracle.sql

purge_decision_oracle.sql

purge_fabric_oracle.sql

purge_hwf_oracle.sql

purge_mediator_oracle.sql

purge_soainfra_oracle.sql


they are self explanatory from their name.

4 comments:

eMarcelCom said...

Hi,

This can be found on the application server host? Or maybe in the installation package...?

Cheers!

Mikku said...

This can be found in Installation package.

Rcu here is the repository creation utility.

Anonymous said...

How to execute this sql "purge_soainfra_oracle.sql" script to purge one/all instances(workflows).

Thanks for any help.

Regards,
Raghav

Mikku said...

What is your exact requirement?

As you can see it has a reference to the following scripts

@@purge_common_oracle.sql
@@purge_hwf_oracle.sql
@@purge_mediator_oracle.sql
@@purge_bpel_oracle.sql
@@purge_decision_oracle.sql
@@purge_fabric_oracle.sql

You can run individual script as per your requirement.