Question
Proximus
BE
Last activity: 7 Aug 2023 10:34 EDT
Tables list in RULES & DATA Schema after multipe upgrades
Hello,
Our applications faced several upgrades from PEGA 6 to 7 to 8, from Single to Split schema and we're now upgrading to 8.4.2.
We're still carrying old tables and tables with same name in both schemas
Is there somewhere available the table list for RULES schema?
Can we consider that table names always indicate in which schema it should be?
It's obvious for PR_DATA & PR4_RULE. Yet, where for PC_ Tables, PR_SYS, PR_INDEX, PR_LOG, etc...?
I need to make some winter cleaning in our schemas.
Thank you
Regards
Anthony
Citicorp Services India Private Limited
IN
Hi Anthony,
Take database backup before performing the below task.
Launch Optimize Schema landing page using below navigation link.
Configure -> System -> Optimize Schema.
Choose schema name from By selecting a database in this field, the sections below will suggest optimizations leading to positive effects in system performance and resource utilization: drop down.
Expand view the unused tables section.
Review the unused tables and drop them if those are not needed anymore.
I hope this helps.
Thanks,