My Oracle Support Banner

How To Purge OWB Execution Audit Tables Using The Truncate Command (Doc ID 430755.1)

Last updated on JULY 31, 2024

Applies to:

Oracle Warehouse Builder - Version 10.1.0.2 to 11.2.0.4 [Release 10.1 to 11.2]
Information in this document applies to any platform.

Goal

Oracle Warehouse Builder Execution Audit Tables can be purged using the following methods:

1. The Runtime Audit Browser (OWB release 10.1.x) / Repository Browser (OWB release 10.2.x and higher)  purge option

2. The  purge API script
$Oracle_Home/owb/rtp/sql/purge_audit_template.sql
or
the package wb_rt_api_purge.purge_execution.


This note provides an alternate script that can be used to truncate the Oracle Warehouse Builder Execution Audit Tables.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.