Database Reference
In-Depth Information
Figure 3-7: Relationship between Physical and Logical architecture of
Oracle database. One object (e.g. table) can be in two or more data files
but only under one tablespace. Each tablespace can have one or more
data files associated with it but each data file can never be associated
with more than one table space. Segments can be sitting under two or
more data files under the same tablespace. Tablespace is nothing but
just an alias given to the group of data files or data file.
Tablespace 2 is comprised of only one data file so all the objects
created by the user will reside in this one data file.
The major
purpose of adding more data files to the tablespace is to remove
the limit of OS defined maximum limit of file size
e.g. those are
familiar with MS Access, know very well that the size of MS
Access “database” can never be more than OS defined maximum
file size.
Search WWH ::
Custom Search