transport_set_check() - Domain Index Stored in System Tablespace and Not in Users Default Tablespace (Doc ID 743835.1)

Last updated on APRIL 22, 2013

Applies to:

Oracle Text - Version 9.2.0.8 to 10.1.0.5 [Release 9.2 to 10.1]
Information in this document applies to any platform.
***Checked for relevance on 22-Apr-2013***

Symptoms

We would like to transport a tablespace set from one database to another. Text index underlying objects are all in the tablespace set being transported.
Executing dbms_tts.transport_set_check() with full_check = true on a tablespace set which contains a table with a domain index but which does not contain the SYSTEM tablespace reports a violation in the view TRANSPORT_SET_VIOLATIONS.

Example:

SQL> Execute sys.dbms_tts.transport_set_check('text_data',TRUE,TRUE);

PL/SQL procedure successfully completed.

SQL> SELECT * FROM sys.transport_set_violations;

VIOLATIONS
------------------------------------------------------------------------------------------
Index TC.TEXTIDX in tablespace SYSTEM points to table TC.TRANSPORT in tablespace TEXT_DATA



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