Aug 12

Oracle Database Objects

Oracle Database ObjectsSchema Objects

  • Clusters
  • Constraints
  • Database links
  • Database triggers
  • Dimensions
  • External procedure libraries
  • Index-organized tables
  • Indexes
  • Indextypes
  • Java classes, Java resources, Java sources
  • Materialized views
  • Materialized view logs
  • Object tables
  • Object types
  • Object views
  • Operators
  • Packages
  • Sequences
  • Stored functions, stored procedures
  • Synonyms
  • Tables
  • Views

Nonschema Objects

  • Contexts
  • Directories
  • Parameter files (PFILEs) and server parameter files (SPFILEs)
  • Profiles
  • Roles
  • Rollback segments
  • Tablespaces
  • Users

What are schema objects?
A collection of logical structures of data, or schema objects. In Oracle, each user owns a single schema and the schema is named after the user.

Non-schema Objects:
Other types of objects stored in the database but not part of any schema.

Both can be manipulated using SQL

Skip to toolbar