Oracle9i™ Development by Example

Answers to Chapter 18

Reviewing It

1:	What is the purpose of the dictionary file?
A1:	You need to create a 'dictionary file' that will contain the redo logs being examined
2:	Briefly describe how you would reverse a database table delete.
A2:	Create dictionary file, use ADDFILE, select UNDO_SQL from V$LOGMNR_CONTENTS where USERNAME = <'username'> and OPERATION = 'DELETE'
3:	What is persistent mode?
A3:	Allows Log Miner to mine the contents of active logs, creating output files in real-time mode.

Checking It

1:	Log Miner can read Oracle v7.3 log files. ...