Schema objects

A schema is a logical structure that contains schema objects. A schema object is a database object that belongs to a schema.

In Oracle mode, a schema is a collection of database objects owned by a user. It is used for permission management and namespace isolation. Generally, one schema corresponds to one application. When a user is created, it has a default schema whose name is the same as the username.

A user can also access and use other schemas. When accessing an object in a schema without specifying which schema the object belongs to, the system automatically adds the default schema name to the object.

Schema objects generally include:

• Tables

• Views

• Indexes

• Partitions

• Sequences

• Synonyms

• Triggers

• PL objects (such as subprograms, packages, and triggers)