Question
Deletion of Some Un-Used table after upgrading from Pega 6.2 SP2 to Pega 7.2.2 from Data Schema
Hello,
Can you please let me know if we can delete the below tables from the Data Schema, please find the table name and corresponding remark/questions
| Un-Used Tables from Data Schema | Question |
| PR_ASSEMBLEDCLASSES_CP | There is no class to DB table mapping exist but this is OOTB table so can you please confirm if we can delete this from Data Schema |
| PR_ENGINECLASSES | There is class to DB table mapping to Rule Schema exist but this table exist in data schema also so we can you please confirm if we can delete this from Data Schema |
| PC_CEP_ACTIONS_REPOSITORY | There is no class to DB table mapping exist but this is OOTB table so can you please confirm if we can delete this from Data Schema |
| PR_LIBGEN | There is no class to DB table mapping exist but this is OOTB table so can you please confirm if we can delete this from Data Schema |
| PR_DATA_VBD_COLLECTION_CONFIG | There is no class to DB table mapping exist but this is OOTB table so can you please confirm if we can delete this from Data Schema |
| PR_FILE_STORE | There is no class to DB table mapping exist but this is OOTB table so can you please confirm if we can delete this from Data Schema |
| PR_EXTRACT_TIME | There is no class to DB table mapping exist but this is OOTB table so can you please confirm if we can delete this from Data Schema |
PR_DATA_VBD_CONFIG | There is no class to DB table mapping exist but this is OOTB table so can you please confirm if we can delete this from Data Schema |
Hello BASAVARAJ,
We have executed the Optimize Schema but still I can see the above table, so can we go ahead and drop the mentioned table as its pega related table and I cannot see any class is mapped to the above mentioned tables? I have cross verified once again and wizard is saying we don't have any un-used table in data schema. But the above table still exist in the Data Schema.
Thanks,
Sudhanshu Kumar Yadav
Hello BASAVARAJ,
Can you please reply on my mentioned question as we have to drop/retain this tables(based on your reply) before moving to next environments.
Thanks,
Sudhanshu Kumar Yadav
Hi Sudhanshu,
Please take the DB back up if you would like to drop the tables.
Regards,
Basavaraj
Hello Sudhanshu,
Try optimizing from Designer Studio > System > Database > Optimize Schema.
This may not remove all your duplicate tables, but as up now we have only this to remove unused tables.
If you can't see Optimize Schema, then you may need to set some privileges. Please check below link for that.
https://pdn.pega.com/system-operations/how-to-set-privileges-to-restrict-database-schema-changes-generated-from-process-commander
Let me know if this helps.
Regards,
Basavaraj