Database Schema | Oracle Schema Objects | What is database schema?

0 Flares Twitter 0 Facebook 0 Google+ 0 LinkedIn 0 Buffer 0 Email -- Filament.io 0 Flares ×

What is schema?
Schema is a collection of schema objects.Schema objects are nothing but a collection of logical structures of dataA schema is owned by a database user and has the same name as that user.
Each user owns a single schema.

The data of each schema object is physically contained in one or more of the tablespace‘s datafiles.
Here one thing to remember that a tablespace can contain objects from different schemas.
There is no relationship between schema and tablespaces.

Using SQL we can create and manipulate Schema objects.
Schema object can be any of the following types ,

  • Clusters,Database links,Dimensions
  • External procedure libraries
  • Java classes, Java resources, and Java sources
  • Materialized views and materialized view logs
  • Object tables, object types, and object views
  • Operators,Synonyms,Sequences,Indexes and index types
  • Stored functions, procedures, and packages
  • Tables ,index-organized tables and views,triggers
  • Database objects like Roles,Tablespaces,Usersetc are not contained in a schema.

    Also Read,

      Technorati Tags:
      , , ,

      0 Flares Twitter 0 Facebook 0 Google+ 0 LinkedIn 0 Buffer 0 Email -- Filament.io 0 Flares ×

      Leave a Reply

      Your email address will not be published. Required fields are marked *

      Paged comment generated by AJAX Comment Page