|René Nyffenegger's collection of things on the web|
René Nyffenegger on Oracle - Most wanted - Feedback
- Follow @renenyffenegger
Oracle database objects
Oracle distinguishes between the following «object»:
All objects that belong to the same user are said to be this user's schema.
Information about existing objects can be retrieved from dba_objects.
It is possible to assign object privileges to objects. These privileges control what other users can do with the objects.
In SQL*Plus, information about tables, views, procedures, functions and packages can be shown with describe.
Oracle stores relevant information about objects (such as their definitions, used storage and so on) in the data dictionary.
The definition of database objects can be retrieved through dbms_metadata.