Oracle database contains schema objects like views, tables, triggers etc., and several other types of objects which are also stored in the database but are not contained in a schema.
A schema is a collection of logical structures of data, or schema objects which is owned by a database user and has the same name as that of the user. Schema objects can be created and manipulated with SQL and include the following types of objects:
Types of Schema Objects
Schema objects are logical data storage structures which do not have a one-to-one correspondence to physical files on disk that store their information. However, Oracle Database stores a schema object logically within a tablespace of the database. The data of each object is physically contained in one or more of the tablespace’s datafiles.
- Tables and index-organized tables
- Constraints
- Views
- Database links
- Database triggers
- Dimensions
- External procedure librarie
- Indexes and indextypes
- Java classes, Java resources, and Java sources
- Materialized views and materialized view logs
- Object tables, object types, and object views
- Operators
- Sequences
- Stored functions, procedures, and packages
- Synonym
- Tables and index-organized tables
- Clusters
Types of NON-SCHEMA Objects
There are several other types of objects which are also stored in the database but are not contained in a schema are:
- Contexts
- Directories
- Parameter files (PFILEs) and server parameter files (SPFILEs)
- Profile
- Roles
- Rollback segments
- Tablespaces
- User
For some objects, such as tables, indexes, and clusters, you can specify how much disk space Oracle Database allocates for the object within the tablespace’s datafiles.