C H A P T E R 4
Tablespaces and Datafiles
As you saw in Chapter 2, when you create a database, typically five tablespaces are created when you execute the
CREATE DATABASE statement:
A tablespace is a logical container that allows you to manage groups of datafiles. A tablespace has one more datafiles associated with it. A datafile can be associated with only one tablespace. In other words, a datafile can't be shared between two tablespaces. A datafile is the physical file that is created on disk. The datafile stores data for database objects such as tables and indexes. Figure 4–1 shows the logical constructs used ...