All the tables that contain information about the database are created by Oracle and their names start with DBA_, ALL_ or USER_.

  • DBA_ views contain all the information about the database and are accessible to users with the DBA role.
  • ALL_ views contain all the information about the database that the current user has access to.
  • USER_ views contain all the information about the database that the current user owns.