no luck SQL> create or replace procedure purge_audit_trail ('91') as 2 purge_date date; 3 begin 4 purge_date := trunc(sysdate-91); 5 dbms_system.ksdwrt(2,'AUDIT: Purging Audit Trail until ' || 6 purge_date || ' started'); 7 delete from aud$ where ntimestamp# < purge_date; 8 commit; 9 dbms_system.ksdwrt(2,'AUDIT: Purging Audit Trail until ' || 10 purge_date || ' has completed'); 11 end; 12 / Warning: Procedure created with compilation errors. SQL> show error Errors for PROCEDURE PURGE_AUDIT_TRAIL: LINE/COL ERROR -------- ----------------------------------------------------------------- 1/30 PLS-00103: Encountered the symbol "91" when expecting one of the following: <an identifier> <a double-quoted delimited-identifier> current delete exists prior On Fri, Mar 30, 2012 at 3:32 AM, kathryn axelrod <kat.axe@xxxxxxxxx> wrote: > Try creating the procedure exactly as listed in the post. In the setup > of the procedure, keep 'days in number'*. Then, when scheduling or > manually running the procedure, replace that variable with the desired > value (e.g. 90). > > *assuming you're using the script from > > http://www.pythian.com/news/1106/oracle-11g-audit-enabled-by-default-but-what-about-purging/ > > > On Thu, Mar 29, 2012 at 2:10 PM, Nagaraj S <nagaraj.chk@xxxxxxxxx> > wrote: > >> I found a script from google but it's giving error > >> SQL> create or replace procedure purge_audit_trail ('90') as > ... > -- //www.freelists.org/webpage/oracle-l