Oracle - Schema Objects

Introduction to 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
• Dimensions
• External procedure libraries
• Indexes and index types
• 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
• Synonyms
• Tables and index-organized tables
• Views

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:

• Contexts
• Directories
• Profiles
• Roles
• Tablespaces
• Users

 

http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10743/schema.htm#i5669