WebSphere

Purging the inactive bucket for an Oracle event database

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

Before you begin

Before you can use the database purge utility for an Oracle database, SQL*Plus must be 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.
Procedure
To purge the inactive bucket, run the stored procedure using SQL*Plus:
sqlplus connect_string @fastpurge.sql

The fastpurge.sql file is stored in the same location as the other scripts generated during database configuration (the default location is profile_root/databases/event/node_name/server_name or cluster_name/dbscripts/oracle).

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


task Task topic

Terms of use | Feedback


Timestamp icon Last updated: 22 June 2010


http://publib.boulder.ibm.com/infocenter/dmndhelp/v6r2mx/topic/com.ibm.websphere.cei.620.doc/doc/tcei_purge_inactive_bucket_oracle.html
Copyright IBM Corporation 2005, 2010. All Rights Reserved.
This information center is powered by Eclipse technology (http://www.eclipse.org).