C H A P T E R  4

images

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:

  • SYSTEM
  • SYSAUX
  • UNDO
  • TEMP
  • USERS

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 ...

Get Pro Oracle Database 11g Administration now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial