Loading Consent Dialog
SID List Listener
Oracle Net Basic Concepts
Remote Login Password file
SQL Plus Worksheet
SQL* Plus CLI
Accept Prompt Commands
Spooling Printing Report
SQL Plus Line Editing Commands
Steps To Change Security Manager
Managing User Roles
DBA_SYS_PRIVS view - Exercise
Query the DBA_SYS_PRIVS view.
This exercise is worth a total of 15 points.
One of your developers has come to you complaining that he cannot create objects in the
tablespace. Upon investigation, you find that there is no freespace left in USERS. Furthermore, you find that a user named
has created several large tables in the tablespace. You didn't think that
had enough quota on the tablespace to create objects that large. Is it possible that
Or does he just have a large quota. You need to find out what's going on.
Which things would you check to figure out why
can use up so much space? If you are planning to query any of the data dictionary tables, write those queries out.
Submitting your Exercise
When you are done with the exercise, click the
button to see the results.