Oracle7 Server SQL Reference

Database Objects

Schema Objects

A schema is a collection of logical structures of data, or schema objects. A schema is owned by a database user and has the same name as that user. Each user owns a single schema. Schema objects can be created and manipulated with SQL and include the following types of objects.

clusters

database links

database triggers^*

indexes

packages^*

sequences

snapshots^*+

snapshot logs^*

stored functions^*

stored procedures^*

synonyms

tables

views

^* These objects are available only if PL/SQL is installed.

⁺ These objects are available only if the distributed option is installed.

Non-Schema Objects

Other types of objects are also stored in the database and can be created and manipulated with SQL, but are not contained in a schema:

profiles

roles

rollback segments

tablespaces

users

Most of these objects occupy space in the database. In this manual, each type of object is briefly defined

, "Commands" in the section describing the command that creates the database object. These commands begin with the keyword CREATE. For example, for the definition of a cluster, see the CREATE CLUSTER command

. For an overview of database objects, see Oracle7 Server Concepts.

You must provide names for most types of objects when you create them. These names must follow the rules listed in the following sections.

Parts of Objects

Some objects are made up of parts that you must also name, such as:

columns in a table or view

integrity constraints on a table

packaged procedures, packaged stored functions, and other objects stored within a package