How to Fix Transport Set Check Violations (DBMS_TTS.TRANSPORT_SET_CHECK)(ORA-39908, ORA-39910, ORA-39932, ORA-39921, etc.)
(Doc ID 1459800.1)
Last updated on FEBRUARY 21, 2024
Applies to:
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and laterOracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Schema Service - Version N/A and later
Information in this document applies to any platform.
Goal
This document shows you how to use DBMS_TTS.TRANSPORT_SET_CHECK to check for self-containment of objects in the transportable set, and how to fix the common violations that are reported.
Solution
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
| Goal |
| Solution |
| The DBMS_TTS.TRANSPORT_SET_CHECK Procedure |
| Common Errors, Causes, and Solutions |
| ORA-29341:The transportable set is not self-contained |
| Error: ORA-39907: Index <index_name> in tablespace <tablespace_name> points to table <table_name> in tablespace <tablespace_name> |
| Error: ORA-39934: Materialized view log <mview_log_name> in tablespace <tablespace_name> and master table <table_name> in tablespace <tablespace_name> are not fully contained in the transportable set |
| Error: ORA-39932: Extensible Index <index_name> not fully contained in the transportable set |
| Error: ORA-39908: Index <index_name> in tablespace <tablespace_name> enforces primary constraints <constraint> of table <table_name> in tablespace <tablespace_name> |
| Error: ORA-39921 Default Partition (Table) Tablespace <tablespace_name> for <object_name> not contained in transportable set' (where object_type either 'Table' or 'Index') |
| Error: Default Partition (Table) Tablespace <tablespace_name> for <table_name> not contained in transportable set |
| ORA-39910: Partitioned Global index string.string in tablespace string points to partition string of table string.string in tablespace string outside of transportable set. |
| References |