- 11 Dec, 2023
- 0 Comments
- 1 Min Read
ORA-56935: Existing Datapump Jobs Are Using A Different Version
While importing in an oracle 12c database, got this error:
Solution :
SQL> SELECT PROPERTY_NAME, SUBSTR (property_value, 1, 30) value FROM DATABASE_PROPERTIES WHERE PROPERTY_NAME LIKE 'DST_%' ORDER BY PROPERTY_NAME; 2 3 4 PROPERTY_NAME -------------------------------------------------------------------------------- VALUE -------------------------------------------------------------------------------- DST_PRIMARY_TT_VERSION 28 DST_SECONDARY_TT_VERSION 14 DST_UPGRADE_STATE DATAPUMP(1)
Check the value of DST_UPGRADE_STATE (1) , Run the below step to make it NONE.
SQL> ALTER SESSION SET EVENTS '30090 TRACE NAME CONTEXT FOREVER, LEVEL 32'; Session altered. SQL> exec dbms_dst.unload_secondary; PL/SQL procedure successfully completed. SQL> SELECT PROPERTY_NAME, SUBSTR (property_value, 1, 30) value FROM DATABASE_PROPERTIES WHERE PROPERTY_NAME LIKE 'DST_%' ORDER BY PROPERTY_NAME; 2 3 4 PROPERTY_NAME -------------------------------------------------------------------------------- VALUE -------------------------------------------------------------------------------- DST_PRIMARY_TT_VERSION 28 DST_SECONDARY_TT_VERSION 0 DST_UPGRADE_STATE NONE
Run the import again, it will work fine
impdp dumpfile=teset2.dmp logfile=imp_teset2.lod directory=ODSFINAL remap_schema=TESTNOTU:BSSTDBA exclude=statistics Import: Release 12.1.0.2.0 - Production on Fri Jan 13 00:42:33 2023 Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved. Username: / as sysdba Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Advanced Analytics and Real Application Testing options Master table "SYS"."SYS_IMPORT_FULL_04" successfully loaded/unloaded import done in AL32UTF8 character set and UTF8 NCHAR character set export done in AL32UTF8 character set and AL16UTF16 NCHAR character set WARNING: possible data loss in character set conversions Starting "SYS"."SYS_IMPORT_FULL_04": /******** AS SYSDBA dumpfile=teset2.dmp logfile=imp_teset2.lod directory=ODSFINAL remap_schema=TESTNOTU:BSSTDBA exclude=statistics Processing object type TABLE_EXPORT/TABLE/TABLE Processing object type TABLE_EXPORT/TABLE/TABLE_DATA . . imported "BSSTDBA"."BAU_PROD_AND_PORT_ID" 956.8 KB 8376 rows Job "SYS"."SYS_IMPORT_FULL_04" successfully completed at Fri Jan 13 00:42:53 2023 elapsed 0 00:00:02