Oracle Database Specificity
In the context of Oracle databases, a schema object is a logical data storage structure.
In an Oracle database, associated with each database user is a schema. A schema comprises a collection of schema objects. Examples of schema objects include:
- tables
- views
- sequences
- synonyms
- indexes
- clusters
- database links
- snapshots
- procedures
- functions
- packages
On the other hand, non-schema objects may include:
- users
- roles
- contexts
- directory objects
Schema objects do not have a one-to-one correspondence to physical files on disk that store their information. However, Oracle databases store schema objects logically within a tablespace of the database. The data of each object is physically contained in one or more of the tablespace's datafiles. For some objects (such as tables, indexes, and clusters) a database administrator can specify how much disk space the Oracle RDBMS allocates for the object within the tablespace's datafiles.
There is no necessary relationship between schemas and tablespaces: a tablespace can contain objects from different schemas, and the objects for a single schema can be contained in different tablespaces.
Read more about this topic: Schema Object
Famous quotes containing the word oracle:
“Know thyself.”
—Inscription on the Oracle of Apollo at Delphi, Greece, 6th century B.C.....