November 2004
Intermediate to advanced
456 pages
12h 52m
English
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 ...
Read now
Unlock full access