Can we truncate pr_index_reference table ?
We are seeing too many records in pr_index_reference table and are having tablespace issues. This is our test environment.
Can we delete few records from this table or truncate this table ?
Is the only feature impacted would be view references ?
In the future, once the tablespace is added, can we repopulate this table ?
Updated: 28 Oct 2022 4:41 EDT
NCS Pte. Ltd
SG
Hi @RajuB398: Truncating this will have impact to view references option in PEGA. Please take this into consideration before truncating this table.
Yes it is used for view references. Even after truncating this, this will get populated (i think during deployment of rules)
Restoring this table after adding tablespace should be fine. But you may need to consider the data which are added by system during the meantime.
Thanks.
LTIMindtree
SA
As Arul Said, It's possible to truncate the DB Table. But what's your objective and reason for Truncating the (pr_index_Ttable_reference) DB Table instead of other DB Tables multiple ones also using lot of storage?