Database Utilities
ContentsOpens a new window
Opens a new window
Page 747 of 1018

LogMiner Dictionary Options

LogMiner requires a dictionary to translate object IDs into object names when it returns redo data to you. LogMiner gives you three options for supplying the dictionary:

  • Using the Online CatalogOpens a new window

    Oracle recommends that you use this option when you will have access to the source database from which the redo log files were created and when no changes to the column definitions in the tables of interest are anticipated. This is the most efficient and easy-to-use option.

  • Extracting a LogMiner Dictionary to the Redo Log FilesOpens a new window

    Oracle recommends that you use this option when you do not expect to have access to the source database from which the redo log files were created, or if you anticipate that changes will be made to the column definitions in the tables of interest.

  • Extracting the LogMiner Dictionary to a Flat FileOpens a new window

    This option is maintained for backward compatibility with previous releases. This option does not guarantee transactional consistency. Oracle recommends that you use either the online catalog or extract the dictionary from redo log files instead.

Figure 20-2Opens a new window shows a decision tree to help you select a LogMiner dictionary, depending on your situation.

Figure 20-2 Decision Tree for Choosing a LogMiner Dictionary

Description of
Description of "Figure 20-2 Decision Tree for Choosing a LogMiner Dictionary"Opens a new window

The following sections provide instructions on how to specify each of the available dictionary options.

Previous PageOpens a new window
Page 747 of 1018
Next PageOpens a new window