Adding a tablespace in PeopleSoft (Tools 8.49.12)

After the DBA has created the table space, you need to add it to PeopleTools table to make it available for the App Designer. Follow these steps to do so

1. Navigate to PeopleTools -> Utilities ->  Administration -> Tablespace Utilities
2. Add another row in the grid, enter Tablespace name, Database name, Type and save. Type would be Regular for most cases. We have a few LOBs for file attachments.

You are done, new Tablespace should show up in App Designer now. If you are adding a new Tablespace just for indexes do not add it to the list of Tablespaces in Tablespace Utilities. Tablespace for indexes can be overriden in record definition. Follow these steps:

1. Open up the record definition up in App Designer 
2. Go to Tools -> Data Administration -> Indexs
3. Select index and click on Edit DDL
4. Go to your database section and select INDEXSPC and click on Edit Parm
5. A new window will pop up and you need to enter the Tablespace name in the Override value field
6. Keep in mind that this method overrides the tablespace only for the index you selected in step3.

Follow these steps if you want to change the tablespace for all newly created indexes (System Wide)

1.  Navigate to PeopleTools -> Utilities -> Administration -> DDL Model Defaults
2. Select your database type, scroll to indexes and change parameter INDEXSPC. See the screenshot below.