How To Purge OWB Execution Audit Tables Using The Truncate Command
(Doc ID 430755.1)
Last updated on SEPTEMBER 22, 2017
Applies to:Oracle Warehouse Builder - Version 10.1.0.2 to 126.96.36.199 [Release 10.1 to 11.2]
Information in this document applies to any platform.
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
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!