Database Tuning (MOSC)

MOSC Banner

ORA-46250: Invalid value for argument 'AUDIT_TRAIL_TYPE'

edited Feb 4, 2025 6:03PM in Database Tuning (MOSC) 1 commentAnswered

I'm using 19.3 and got this error.

I am not sure why it doesn't go through…

BEGIN
2 DBMS_AUDIT_MGMT.SET_LAST_ARCHIVE_TIMESTAMP(
3 AUDIT_TRAIL_TYPE => DBMS_AUDIT_MGMT.AUDIT_TRAIL_DB_STD,
LAST_ARCHIVE_TIME => SYSTIMESTAMP - INTERVAL '2' MONTH
);
5 6 END;
7 /
BEGIN
*
ERROR at line 1:
ORA-46250: Invalid value for argument 'AUDIT_TRAIL_TYPE'
ORA-06512: at "AUDSYS.DBMS_AUDIT_MGMT", line 208
ORA-06512: at "AUDSYS.DBMS_AUDIT_MGMT", line 1065
ORA-06512: at line 2

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center