Month: September 2006

Tip — PeopleTools: Tablespaces What happens when…

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 Statement:
INSERT INTO PSTBLSPCCAT (DDLSPACENAME, DBNAME, TSTYPE, DBXTSTYPE, COMMENTS) VALUES (‘TABLESPACE_NAME’, ‘ ‘, ‘R’, ‘DMS’, ‘Your Comments’);

More Information on Tablespaces
PeopleTools tables: PSTBLSPCCAT
http://peoplesoft.ittoolbox.com/groups/technical-functional/peoplesoft-fi-l/creating-new-tablespace-in-ps84-489136#