Oracle logical structures

Oracle logical structures

Oracle logical structures can be summarised by the following:
Schema. Tablespace. Datablock. Redo log.

Schema

  • collection of objects (table, view, etc)
  • owned by db user
  • name is the same as db user
  • mixed up (user is often used interchangeably with schema)
  • access – user has access to all objects in schema
  • name – user only has access to schema of the same name

Tablespace

  • Logical storage units – oracle divided into one or more logical storage units
  • objects – tablespace stores related database objects
  • access – tablespace can be online (accessible) or offline (not accessible)
  • normally online so users can access data

Datablock

Leave a Reply