Posted: 16 Mar 2017 15:37 EDT Last activity: 24 Mar 2017 8:44 EDT
Delete rows in pr_sys_ruleset_index
Can I just delete rows or truncate pr_sys_ruleset_index without any issues?
We're encountering table space issues in our environment and the DBA can no longer extend the table space. It turns out pr_sys_ruleset_index is using more than half of the table space for our RULES schema. I've read some of the topics about this table and the usual root cause is due to this table usually doesn't have a PK defined and the data is duplicating. However our DBA has confirmed that this table has a PK and it doesn't have duplicates. I'm thinking if it's ok to truncate this table and just rebuild the index.
***Updated by moderator: Lochan to add Categories***
Our space issue was resolved when the DBAs did a DB REORG on 4 development schemas including the schema of the impacted environment. After the REORG, they were then able to extend the tablespace. I was advised by our LSAs not to truncate the rows since it would significantly slow down the environment.