Purging data from the BPEL store

In this recipe we will remove old BPEL dehydration data and state from the SOA infrastructure database.

Getting ready

You will need to have access to the database on which the SOA_INFRA schema is hosted. In this recipe, we'll be using a command line local to the host on which we installed the database.

You'll also need access to the SQL scripts bundled with SOA Suite. If you have SOA Suite installed on the host running the database, you can find them under MW_HOME/SOA_ORACLE_HOME/rcu/integration/soainfra/sql/soa_purge.

If the database is running on a separate host, you can simply copy the soa_purge directory from the WebLogic administration server to a directory on the database host; we'll be using e:\soa_purge for this purpose.

How to do it...

Follow these steps to run the soa_purge scripts:

1. First, log in to sqlplus as a user with sysdba privileges, and grant the following permissions to the dev_soainfra user, then exit the shell:

   sqlplus / as sysdba
   SQL> GRANT...