Types of Oracle Database Objects

Types of Oracle Database Objects

Oracle Database objects are with consider or present in schema and not present in schema as follows. divided into two catagory

Schema objects
Non-Schema objects

Schema Objects
A schema is a logical structures of data or schema objects. A schema has same name as user. Each user map with a single schema.

Schema has following types of 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
Mining models
Object tables
Object types
Object views
Operators
Packages
Sequences
Stored functions, stored procedures
Synonyms
Tables
Views

Nonschema Objects
Objects present in database but are not present in a schema. Handled by SYS or SYSTEM schema only:

Following are the list of Nonschema objects

Contexts
Directories
Editions
Restore points
Roles
Rollback segments
Tablespaces
Users

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.