Oracle 9i Database Administration in 10 Minutes
CH1: Understanding the Oracle Environment | CH2: Understanding the Oracle Instance | CH3: Understanding the working of Oracle Instance | CH4: Understanding Oracle Database | CH5: Oracle 9i Software Installation | CH6: Oracle 9i Database Design using DBCA | CH7: Enabling Other Computers to Access Oracle Server | CH8: Oracle Enterprise Manger | CH9: Oracle Backup & Recovery -Simple Technique | CH10: Oracle Performance Tuning
Chapter 4: Understanding Oracle Database
Tablespaces are like small departmental level databases. Data inside
these tablespaces resides in the data a file. If there is only one data
file associated with the tablespace then the maximum size of the
tablespace cannot be more than the Operating System maximum files size.
But you can always add another data file to the tablespace. In this way
the maximum size of tablespace is not limited to the OS marked limit on
file size.
Figure 13: Tablespaces relates to data files only.
________________________________________
When we talk about the relationship between logical
and physical architecture of database, we mean that we are talking about
how tablespaces are related to the data files. Each tablespace can have
one or more data files associated with it but each data file can never
belong to more than one tablespace.
Chapter 4: Understanding Oracle Database
CH1: Understanding the Oracle Environment | CH2: Understanding the Oracle Instance | CH3: Understanding the working of Oracle Instance | CH4: Understanding Oracle Database | CH5: Oracle 9i Software Installation | CH6: Oracle 9i Database Design using DBCA | CH7: Enabling Other Computers to Access Oracle Server | CH8: Oracle Enterprise Manger | CH9: Oracle Backup & Recovery -Simple Technique | CH10: Oracle Performance Tuning