The database reclamation utility continues to fail

Products

• Data Loss Prevention Enforce

Issue/Introduction

If the database reclamation utility (DLP_lobspace_reclaim.sql) fails, subsequent attempts also fail. 

The following error is encountered while running reclamation utility:

 

ORA-12089: cannot online redefine table "DLP_USER"."MESSAGECOMPONENTLOB_TMP" with no primary key

ORA-06512: at "SYS.DBMS_REDEFINITION", line xx

ORA-06512: at "SYS.DBMS_REDEFINITION", line xxxx

ORA-06512: at "SYS.DLP_LOBSPACE_MGMT", line xxx

ORA-06512: at line xx

This error indicates there was another failed run before which causes this to happen. 

Cause

When the database reclamation utility runs, it creates new _TMP tables to make a temporary copy of the current LOB_TABLESPACE.

If it fails, the _TMP tables remain.

If the tool is run again, instead of using the current _TMP tables, it creates _TMP tables from the _TMP tables resembling 'MESSAGELOBCOMPONENT_TMP_TMP', which are invalid tables for the tool to run.

Resolution

A new version of the DLP_lobspace_reclaim.sql script is scheduled for the DLP 15.5 release. For earlier versions, please contact Technical Support.