Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

What are the relationships between these elements: Tablespace, Oracle data block, Extent, Segment, Data file?

user-image
Question added by Deleted user
Date Posted: 2015/08/01
abdullah aldubai
by abdullah aldubai , database administrator , Techzone Training Services Ltd

Tablespace is a logical structure of a database . a file which can see in the OS level is called physical structure ex :- datafile .

in oracle db data is going to store in segment and segment is collection of Extents and Extents made up of configuration ( means without any gap ) database blocks and database block made up of os block which part of datafile .

More Questions Like This