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.
The procedure for creating a PeopleSoft database is described in the PeopleSoft installation ...