Patch 6501312 - BPEL Repository spring cleaning

A new patch with id 6501312 creates a purge_instances procedure in the oraclebpel schema that you can use to delete your old BPEL Process instances.

Currently (Thu Dec 13 15:36:56 CET 2007) there seemes to be a problem with the paths for this patch in unix so I installed it using the following procedure:

1 Copy the files in 6501312/files/bpel\system\database\scripts to $ORACLE_HOME/bpel/system/database/scripts

2. Run the sqlplus scrip to create index and create the procedure "purge_instances".

Example:

bash$ sqlplus /nolog
SQL*Plus: Release 10.1.0.5.0 - Production on Thu Dec 13 10:19:06 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> connect orabpel@instance
Enter password:
Connected.
SQL> @upgrade_6501312_oracle.sql
SQL> commit;
SQL> @purge_instances_oracle.sql

After this you may start your spring cleaning:

BEGIN
purge_instances(to_timestamp('2007-12-13 10:30:25','YYYY-MM-DD HH24:MI:SS'));
COMMIT;
END;

Happy cleaning!

Sphere: Related Content