CTXSYS.DRI_MOVE_CTXSYS Does Not Move All CTXSYS Objects
Last updated on AUGUST 08, 2012
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.
execute CTXSYS.DRI_MOVE_CTXSYS ('CTX_DATA');
-- Display all objects left in SYSAUX
SELECT DECODE(partition_name, NULL,
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms