Tip — PeopleTools: Tablespaces
What happens when you decide to create a new record and PeopleSoft asks you which tablespace to use, but the tablespace you want is not in the list?
Solution: Insert a Row into the PeopleTools System Catalog table.
As far as I know, PeopleSoft offers no other way of adding tablespaces as options.
INSERT INTO PSTBLSPCCAT (DDLSPACENAME, DBNAME, TSTYPE, DBXTSTYPE, COMMENTS) VALUES (‘TABLESPACE_NAME’, ‘ ‘, ‘R’, ‘DMS’, ‘Your Comments’);
More Information on Tablespaces
PeopleTools tables: PSTBLSPCCAT