Posted: 7 May 2018 5:16 EDT Last activity: 7 May 2018 7:15 EDT
PMD 126.96.36.199.GA on SLES - object reference for CB* or OT_TMP* not found
in times of GDPR we need to check our data objects and if they can be housekept and/or deleted. So far we checked the PMD repository and found some tables with no reference in the OBJ_TYPE table. i check the provided purge document and script.
Now my question:
The procedure purge_CStables only lookup table from cancelled / completed campaigns like
WHERE db_ent_name LIKE 'CS%_%_%' ...
and drops the tables from repository.
The deleted CS tables.have the obj_type_id = 27
All the table we looking for like CB* and OT_TMP_*.
Has the same obj_type_id = 27 like the CS tables.
Could i drop the tables if referenced campaign status is complete or cancelled?
We have 5404 table called like F1080_1_18984_27_0
select * from all_tables where owner='ADVANTAGE' and table_name like 'F%_%_%'