4 Replies Latest reply on Aug 5, 2020 9:14 AM by Pandiarajan B

    Purging MDM HIST and HXRF tables

    Inbaraj Anbalagan Active Member

      Hi Folks,


      We Are using MDM 10.2.2 and we are facing DB space issue as we have enabled history on all our Base Objects.


      We want do a periodic purging incrementally, by maintaining only last 10 versions of a ROWID_OBJECT

      w.r.t. BO_HIST tables and similarly latest 10 versions of ROWID_XREF w.r.t. to BO_HXRF tables.


      We have to do this purging activity without bringing MDM down?



      Please share your thoughts.