Extended DB Features
Oracle SQL Extensions
Local Index Partition
Dropping Oracle Partitions
Drop Truncate Partitions
Clustered Tables Advantages
Oracle Hash Cluster
Creating Oracle Cluster
Size Cluster Properly
Oracle Clustering Advantages
Export Table Data
Creating Table Index
Enable Audit Feature
Purge Audit Trail
National Character Set
Viewing audit records - Exercise
Viewing audit records
Create SQL statements to view audit records.
This exercise is worth 5 points. After you have completed your answer, submit your answer.
In the last exercise, you created a script that turned on auditing for a number of possible actions. In this exercise, you will create a SQL script that will report on the audit records collected.
You can download a correct version of the script for this exercise from the course Resources page.
Select the rows from the appropriate data dictionary table to display the name of the user who performed an audited action, the time the action took place, and the type of action that occurred.
Sort the actions by the time the actions occurred.
You will need only one SQL statement to retrieve this data.
You will want to view all audit records for all users, so you should use the
version of the appropriate data dictionary view.
Submitting your exercise
Submit your answer in the text box below.