Title
Purge B2B runtime data from the command prompt

Date
2007-10-16

Summary
Purging B2B runtime data can be done through the command prompt or from SQL*Plus. As a very rough estimate, it takes approximately 1 minute to purge 10,000 records on a dual CPU server.

Details
1. Set up the environment by using the fully qualified path (do not type '$ORACLE_HOME'): 
. /u01/app/oracle/product/10.1.2/b2b_1/ip/install/setenv.sh

2. Change into the $ORACLE_HOME/ip/install directory before executing the command: 
cd /u01/app/oracle/product/10.1.2/b2b_1/ip/install

3. Examples of purging are the following: 
java oracle.tip.repos.purge.PurgeManager purgeRuntime -start 01-JAN-2008 -end 10-JAN-2008 Complete
java oracle.tip.repos.purge.PurgeManager purgeRuntime -start 01-JAN-2008 -end 10-SEP-2008 Error

4. Alternatively, you can SQL*Plus into the database and execute the purge_runtime procedure: 
sqlplus b2b@orcl
SQL> exec purge_runtime('21-JAN-2008', '07-FEB-2008', 'Complete');

Applicable Versions
Oracle B2B 10g (10.1.2.0.2)
Ahmed Aboulnaga
.com .com