C H A P T E R 7
Tablespaces
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 also discuss some of the options you have to make life a little easier when managing tablespaces.
In the PeopleSoft installation procedure, 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
Creating a new PeopleSoft database from scratch is not something that DBAs need to do very often. ...
Get PeopleSoft for the Oracle DBA 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.
