My Oracle Support Banner

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 to [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

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.


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

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