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.
Reset
3.15.147.215