Tablespace : A tablespace is a storage location, where the
objects are stored like tables, indexes, functions, procedures... Tablespace is
intermediate between logical and physical components of oracle. A tablespace is
made up of one or more datafiles.
Types of Tablespaces:
1. User data tablespaces
2. Temp Tablespaces
3. Undo Tablespaces
Segment: Segment is a database object , which is allocated
to some space to it. Segments are consists one or more extents. A segment can
span to one tablespace.
Extents: Extent is a contiguous oracle data bocks. Extents
are allocated to segments.
Blocks: Block is a smallest unit of storage in oracle. By
default oracle block size is 8k.
No comments:
Post a Comment