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:
“There be three things which are too wonderful for me, yea, four which I know not: the way of an eagle in the air; the way of a serpent upon a rock; the way of a ship in the midst of the sea; and the way of a man with a maid.”
—Bible: Hebrew Proverbs, 30:18-19.
From the oracle of Agur, son of Jakeh.