My Oracle Support Banner

TRANSPORTABLE TABLESPACE IMPORT FAILS WITH ORA-39083 ORA-942 ON MDRS TABLES (Doc ID 2031174.1)

Last updated on MARCH 14, 2019

Applies to:

Oracle Spatial and Graph - Version 12.1.0.1 to 12.1.0.2 [Release 12.1]
Information in this document applies to any platform.

Symptoms

We perform a Transportable Tablespace (TTS) export of the tables from 12.1.0.1, to import the data (with pre-built spatial indexes) into the Production System 12.1.0.2
The import was run using the following:

IMPDP parfile:
logfile=exp_data.dmp.implog
dumpfile=exp_data.dmp
directory=TTS_DIR_23736
transport_datafiles='+<path/file>'

and resulted in this error message in the import logfile:

 

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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