Examples Using LogMiner

This section provides several examples of using LogMiner in each of the following general categories:

• Examples of Mining by Explicitly Specifying the Redo Log Files of Interest

• Examples of Mining Without Specifying the List of Redo Log Files Explicitly

• Example Scenarios

  Note:

  All examples in this section assume that minimal supplemental logging has been enabled:

  SQL> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
  

  See "Supplemental Logging" for more information.

  All examples, except "Example 2: Mining the Redo Log Files in a Given SCN Range" and the "Example Scenarios", assume that the NLS_DATE_FORMAT parameter has been set as follows:

  SQL>  ALTER SESSION SET NLS_DATE_FORMAT = 'dd-mon-yyyy hh24:mi:ss';

  Because LogMiner displays date data using the setting for the NLS_DATE_FORMAT parameter that is active for the user session, this step is optional. However, setting the parameter explicitly lets you predict the date format.