PSRECTBLSPC table in STAT Staging database has entries for custom tables.
説明
We are upgrading the PeopleTools version of Stat Staging database from 8.53 to 8.55. The upgrade job is running into an error while running the setspace.sqr program which verifies the tablespace setting for table definitions. Specifically, the process looks at the the PSRECTBLSPC table and verifies that each PeopleSoft record (or Oracle table) definition has a valid tablespace defintion. The process is showing that many tables it is expecting to see are not defined in the database. Most of these tables are custom tables and would never have been created in the staging database since they are PeopleSoft application tables that only exist in our DEV, TST, QA, PROD environements. Why would these table definitions be defined within the PSRECTBLSPC table within the STAT Staging database?
対策
PSRECTBLSPC is a table that stored every record when migrating from source to the staging db.
