search cancel

The database reclamation utility continues to fail


Article ID: 171999


Updated On:


Data Loss Prevention Enforce


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. 


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.


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.


Fix get_app