CHAPTER 7Tablespaces

This chapter looks at the various tablespaces that PeopleSoft creates in an Oracle database and how they are used. Some of the choices that PeopleSoft has made are a little surprising, such as the decision to have many tablespaces for tables but only one for indexes. So, I will also discuss some of the options you have to make life a little easier when managing tablespaces.

In the PeopleSoft installation procedure, all of the default tablespaces in the database are created immediately after the database is created. Therefore, this is also a suitable place to consider how to create the database in the first place.

Database Creation

The procedure for creating a PeopleSoft database is described in the PeopleSoft installation ...

Get PeopleSoft for the Oracle DBA now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.