This content has been marked as final. Show 2 replies
Small correction, whether it is not available in the delivered Windows binaries, we can run that sqr from the App/Batch server as following :
But it would have been nice if that was already executed onto the database by default, as indicated in the Peopletools Installation Guide Task 7B-10: Running SETSPACE.SQR when building manually a database on Unix.
[psadm2@psovmhcm sqr]$ pwd /opt/oracle/psft/pt/tools/sqr [psadm2@psovmhcm sqr]$ /opt/oracle/psft/pt/tools/bin/sqr/ORA/bin/sqr ./setspace.sqr sysadm/SYSADM@H91TMPLT -zif./pssqr.ini -i./ -f../log/setspace.log -keep -PRINTER:HT SQR for PeopleSoft V8.51 Set Table Space Name in PSRECTBLSPC Table PSRECTBLSPC column DDLSPACENAME have been updated with the tablespace found in the system catalog table. Detailed below are those tables that were not updated because they have not yet been created in the database. The total number of records updated appears at the bottom of this report. Recname Tablespace --------------- ---------------- ... Ending SQR. SQR for PeopleSoft: End of Run. [psadm2@psovmhcm sqr]$
Seems to be fixed within the latest Peoplesoft OVM FSCM 9.1 Feature Pack 1 running on Peopletools 8.51.07 released on APR-2011.