OATM migration leaves WF_CONTROL objects in the old tablespace (Doc ID 418238.1)

Symptoms

OATM migration terminates successfully, but some AQ object related to WF_CONTROL was left in the old tablespace. That can be checked running:

select segment_name, segment_type from dba_segments where tablespace_name ='APPLSYSD';
SEGMENT_NAME                       SEGMENT_TYPE
------------------------------         ------------------
SYS_IL0002889820C00006$$     LOBINDEX
SYS_LOB0002889820C00006$$ LOBSEGMENT

select OWNER, TABLE_NAME from dba_lobs  where SEGMENT_NAME in  ('SYS_LOB0002889820C00006$$', 'SYS_IL0002889820C00006$$')
OWNER              TABLE_NAME 
-----------------  ------------------------------
APPLSYS            AQ$_WF_CONTROL_D

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.