CTXSYS.DRI_MOVE_CTXSYS Does Not Move All CTXSYS Objects
(Doc ID 860456.1)
Last updated on MARCH 28, 2019
Applies to:Oracle Text - Version 10.2.0.1 to 188.8.131.52 [Release 10.2 to 11.2]
Information in this document applies to any platform.
This problem can occur on any platform.
Executing the procedure CTXSYS.DRI_MOVE_CTXSYS to move all of the CTXSYS owned objects from the SYSAUX tablepsace to a different tablespace did not move all of the CTXSYS objects out of the SYSAUX tablespace.
--Move the objects.
-- Display all objects left in SYSAUX
owner || '.' || s.segment_name,
owner || '.' || s.segment_name || '.' || s.partition_name),
segment_type, bytes/1024, extents
FROM sys.dba_segments s, ctxsys.dr$dbo m
WHERE s.tablespace_name = 'SYSAUX' and s.owner like '%CTXSYS%'
AND m.dbo_name = s.segment_name;
This returns rows.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document