Question
4
Replies
175
Views
Labb Consulting
Posted: July 25, 2017
Last activity: August 1, 2017
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 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