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.
 |
Replace PS_HOME above with the appropriate location for your PeopleSoft installation.
