This discussion is archived
4 Replies Latest reply: Jun 28, 2013 10:24 AM by jack m RSS

DBMS_AUDIT_MGMT.set_last_archive_timestamp & AUDIT_TRAIL_ALL

jtokarsk Newbie
Currently Being Moderated
Hi folks, I have starred at this for a while. When I issue the following

audit_trail_type => DBMS_AUDIT_MGMT.AUDIT_TRAIL_ALL,
last_archive_time => SYSTIMESTAMP-5);

I keep getting the following error:

ERROR at line 1:
ORA-46250: Invalid value for argument 'AUDIT_TRAIL_TYPE'
ORA-06512: at "SYS.DBMS_AUDIT_MGMT", line 61
ORA-06512: at "SYS.DBMS_AUDIT_MGMT", line 2233
ORA-06512: at line 2

Yet as near as I can tell this is a valid constant (
for this procedure(

Has anyone ran into this?

Edited by: jtokarsk on Mar 23, 2012 5:47 PM


  • Correct Answers - 10 points
  • Helpful Answers - 5 points