purge_audit_template
- From: Ray Stell <stellr@xxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Sun, 9 Nov 2008 17:11:08 -0500
the purge_audit_template is not well documented. It gives these examples:
rem sqlplus user/password@tns_name @purge_audit_template.sql MY_WORKSPACE
DEPLOYMENT ALL null null
rem sqlplus user/password@tns_name @purge_audit_template.sql MY_WORKSPACE
EXECUTION "number_task_errors > 0" null null
rem sqlplus user/password@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
Other related posts: