Oracle未开启审计情况下追踪表变更记录(2)

SQL> SELECT name, supplemental_log_data_min FROM v$database;

NAME                           SUPPLEME
------------------------------ --------
M10202WA                       YES

Ensure that all archive redo logs containing the necessary redo information have been added to the LogMiner session.

Ensure that the COMPATIBLE initialization parameter is set to 8.1.0 or higher.

SQL> show parameter compatible

NAME                                 TYPE        VALUE
------------------------------------ ----------- ----------
compatible                           string      10.2.0.2.0

For Oracle8i and Oracle9i only: ensure that the TRANSACTION_AUDITING instance parameter is set to TRUE (default).

SQL> show parameter transaction_auditing

NAME                                 TYPE        VALUE
------------------------------------ ----------- ----------
transaction_auditing                 boolean     TRUE