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

Last updated on JULY 13, 2015

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_moj_data.dmp.implog
dumpfile=exp_moj_data.dmp
directory=TTS_DIR_23736
transport_datafiles='+DG1/MOJTST01/DATAFILE/moj_data_150520.379.883760161'

and resulted in this error message in the import logfile:

 

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