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. True/False |
| A1: | False, 8.0 on |
| 2: | Which of the following is NOT valid syntax?
|
| A2: | c |
| 3: | Log Miner can be used as an audit trail. True/False |
| A3: | True. |
 | Applying It |
Independent Exercise 1:
- Make sure your database is in Archive Log mode
- Delete all the records from the SCOTT.EMP table.
- Use Log Miner, find the records, and make an UNDO script
- Apply the UNDO Script
- Query the SCOTT.EMP table
Independent Exercise 2:
- Check to see what activity the user SCOTT has been doing to the database
- Check to see who has done what kind of activity to the SCOTT.EMP table
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.