Oracle Internals

Oracle 10.1 Audit Actions

In Oracle 9.2 there were 144 audit actions; in Oracle 10.1 there are 154 audit actions

The following table shows the 16 audit actions that were added in Oracle 10.1:

Action	Name
71	CREATE MATERIALIZED VIEW LOG
72	ALTER MATERIALIZED VIEW LOG
73	DROP MATERIALIZED VIEW LOG
74	CREATE MATERIALIZED VIEW
75	ALTER MATERIALIZED VIEW
76	DROP MATERIALIZED VIEW
128	FLASHBACK
129	CREATE SESSION
197	PURGE USER_RECYCLEBIN
198	PURGE DBA_RECYCLEBIN
199	PURGE TABLESAPCE
200	PURGE TABLE
201	PURGE INDEX
202	UNDROP OBJECT
204	FLASHBACK DATABASE
205	FLASHBACK TABLE

The following table shows the six audit actions that were removed from Oracle 10.1: