O'Reilly logo

Pro Oracle Database 11g Administration by Darl Kuhn

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required