DATABASE VIEW NOTES:

Owner - Owner of the view

View Name - Name of the view

Created - Date/time view was created

Status - Status of the view

Views are virtual looks at tables. They don't exist until queried except as a specification statement stored in the database.

A single view can be very efficient, but the "stacking" of views, that is, views that reference views that reference views, can show a performance problem.

If you attempt to create a view using grants received from a role you will get an ORA-01933 error. You must have direct grants on all objects used in the view definition.