CTXSYS.DRI_MOVE_CTXSYS Does Not Move All CTXSYS Objects (Doc ID 860456.1)

Last updated on AUGUST 08, 2012

Applies to:

Oracle Text - Version 10.2.0.1 to 11.2.0.3 [Release 10.2 to 11.2]
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

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.

Cause

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