Schema objects
A schema is a collection of logical structures of data, or schema objects. A schema is owned by a database user. Each user can own a single schema. Schema objects can be created and manipulated with SQL and include the following types of objects:
- Tables
- Views
- Procedures
- Functions
- Triggers, DB and Schema Triggers
- Indexes
- Packages, Package Bodies
- Sequences
- Clusters
- Materialized Views, Materialized View Logs
- Synonyms
- Database Links
- Object Types, Object Type Bodies
- Array Types
- Libraries
- Java Sources, Java Classes, Java Resources
- Index Types
- Operators
- Dimensions
- Queues
- Queue Tables
Use the DB Explorer tree to navigate within the existing schemas and their objects.