Info
Content

# No Tablespaces

After completing an PeopleSoft installation, I found that I had missed a step as there were no table spaces available to save a new record definition into.

You can check this in application designer using the following steps:

• Open a record definition
• Tools > Data Administration > Set Table Space
• Look at the available space Name-DB Name. If you have no options (blank) then no table spaces are defined.

Another way to check this is through:

PeopleTools > Utilities > Administration > Tablespace Utilities:

No tablespaces! Behind the scenes, the table that needs to be populated is `PSTBLSPCCAT`.

The step that I had missed as part of the installation was to run the SQR, `setspace.sqr`.

Start `sqrw.exe` (found under `PS_HOME\bin\sqr\<DB>\binw\`). Specify the appropriate parameters and run.

NOTE: Replace PS_HOME above with the appropriate location for your PeopleSoft installation.