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.