purge_audit_template

From: Ray Stell <stellr_at_cns.vt.edu>
Date: Sun, 9 Nov 2008 17:11:08 -0500
Message-ID: <20081109221108.GA12199@cns.vt.edu>


the purge_audit_template is not well documented. It gives these examples:

rem   sqlplus user/password_at_tns_name @purge_audit_template.sql MY_WORKSPACE DEPLOYMENT ALL null null
rem   sqlplus user/password_at_tns_name @purge_audit_template.sql MY_WORKSPACE EXECUTION "number_task_errors > 0" null null
rem   sqlplus user/password_at_tns_name @purge_audit_template.sql MY_WORKSPACE EXECUTION DATE_RANGE TO_DATE('01-Jan-2004') SYSDATE

the 11g docs are pretty thin on the topic. What are these things:

How is this thing used? 11g does a bunch of auditing out of the box and fills up the system tablespace as a side benefit with little guidance on the topic. I tried to use the scirpt without much understanding and get:

call owbsys.wb_rt_script_util.set_workspace('MY_WORKSPACE')

     *
ERROR at line 1:
ORA-06576: not a valid function or procedure name

--
http://www.freelists.org/webpage/oracle-l
Received on Sun Nov 09 2008 - 16:11:08 CST

Original text of this message