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.
No Comments
Back to top