Shulou(Shulou.com)05/31 Report--

This article mainly explains "how to solve oracle 12c to import a 11.2.0.1 data pump export file into version 12.1.0.2 error", interested friends may wish to take a look. The method introduced in this paper is simple, fast and practical. Let's let Xiaobian take you to learn "how to solve oracle12c to import a 11.2.0.1 data pump export file into version 12.1.0.2 error"!

/*

When importing a 11.2.0.1 data pump export file into version 12.1.0.2, the following error occurred

Connect to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

ORA-39006: Internal Error

ORA-39065: Unexpected main process exception error in DISPATCH

ORA-56935: Existing data pump job is using another version of time zone data file

ORA-39097: Unexpected Error in Data Pump Operation-56935

After searching for half a day, I found the following solution.

*/

--Inquiry

SELECT PROPERTY_NAME, SUBSTR (property_value, 1, 30) value

FROM DATABASE_PROPERTIES

WHERE PROPERTY_NAME LIKE 'DST_%'

ORDER BY PROPERTY_NAME;

--DST_PRIMARY_TT_VERSION26

--DST_SECONDARY_TT_VERSION0

--DST_UPGRADE_STATE DATAPUMP(2)

--Execute DATAPUMP(2) twice in the command window according to the query result above. DATAPUMP(5) executed 5 times

ALTER SESSION SET EVENTS '30090 TRACE NAME CONTEXT FOREVER, LEVEL 32';

exec dbms_dst.unload_secondary;

--Query again after execution

SELECT PROPERTY_NAME, SUBSTR (property_value, 1, 30) value

FROM DATABASE_PROPERTIES

WHERE PROPERTY_NAME LIKE 'DST_%'

ORDER BY PROPERTY_NAME;

--DST_PRIMARY_TT_VERSION26

--DST_SECONDARY_TT_VERSION0

--DST_UPGRADE_STATE NONE

--The execution result is as shown above, try to restore again successfully!!

At this point, I believe that everyone has a deeper understanding of "how to solve oracle 12c to import a 11.2.0.1 data pump export file into version 12.1.0.2 error", may wish to actually operate it! Here is the website, more related content can enter the relevant channels for inquiry, pay attention to us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.