WebSphere WebSphere Enterprise Service Bus, Version 6.0.1 Operating Systems: AIX, HP-UX, Linux, Solaris, Windows

Purging the inactive bucket for an Oracle database

The rapid purge utility for an Oracle event database is implemented as a stored procedure.

Before you begin

To use the utility for an Oracle database, you must have SQL*Plus installed on the Oracle client, and the client must be configured to communicate with the Oracle database (the tnsnames.ora file must be configured properly). Refer to the Oracle documentation for more information.

Steps for this task

To purge the inactive bucket, run the stored procedure using SQL*Plus:
sqlplus connect_string @fastpurge.sql

The connect_string parameter is the Oracle connection string. Use the same database user ID used to create the event database.


Task topic

Terms of Use | Rate this page

Timestamp iconLast updated: 13 Dec 2005
http://publib.boulder.ibm.com/infocenter/dmndhelp/v6rxmx/index.jsp?topic=/com.ibm.websphere.wesb.doc\doc\tcei_admin_purgeInactiveBucketOracle.html

(C) Copyright IBM Corporation 2005. All Rights Reserved.
This information center is powered by Eclipse technology. (http://www.eclipse.org)