In this recipe we will remove old BPEL dehydration data and state from the SOA infrastructure database.
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
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 ...