what do you really mean by pre-process the audit tables before upgrade to 11g r2 from 10.2.0.5.0
hi,
i base my questions on note: 1329590.1
i was expecting some export of the audit records before upgrading but base on this note the steps is just:
Steps: 1: Check the number of rows in the Audit tables: Standard Auditing
SELECT count(*) FROM sys.aud$ WHERE dbid is null;
Standard Auditing, only when Oracle Label Security (OLS) and/or Database Vault (DV) is installed
SELECT count(*) FROM system.aud$ WHERE dbid is null;
Fine Grained Auditing
SELECT count(*) FROM sys.fga_log$ WHERE dbid is null;
Am i missing somethings, how do i go about using this select result to really pre-process my audit records during normal operations.
i base my questions on note: 1329590.1
i was expecting some export of the audit records before upgrading but base on this note the steps is just:
Steps: 1: Check the number of rows in the Audit tables: Standard Auditing
SELECT count(*) FROM sys.aud$ WHERE dbid is null;
Standard Auditing, only when Oracle Label Security (OLS) and/or Database Vault (DV) is installed
SELECT count(*) FROM system.aud$ WHERE dbid is null;
Fine Grained Auditing
SELECT count(*) FROM sys.fga_log$ WHERE dbid is null;
Am i missing somethings, how do i go about using this select result to really pre-process my audit records during normal operations.
0