Purging FRM_REPOSITORY_LOBS & RG_REPORT_REQUEST_LOBS
Hi, I am not sure if this is the write community group to post to, thus, please move it the right group if not Performance.
After an OATM project the implementor realized that our tables FRM_REPOSITORY_LOBS & RG_REPORT_REQUEST_LOBS are hug and was unable to convert FRM_REPOSITORY_LOBS to OATM and locally managed table-spaces. Now, for RG_REPORT_REQUEST_LOBS I used the Repository Report Manager to delete existing FSG published XML reports but that did not reduce the size even after I did "Shrink table" on it. As for FRM_REPOSITORY_LOBS which the most critical as it is still in FRMD and FRMX table-spaces. My questions are as follows:
After an OATM project the implementor realized that our tables FRM_REPOSITORY_LOBS & RG_REPORT_REQUEST_LOBS are hug and was unable to convert FRM_REPOSITORY_LOBS to OATM and locally managed table-spaces. Now, for RG_REPORT_REQUEST_LOBS I used the Repository Report Manager to delete existing FSG published XML reports but that did not reduce the size even after I did "Shrink table" on it. As for FRM_REPOSITORY_LOBS which the most critical as it is still in FRMD and FRMX table-spaces. My questions are as follows:
0