1 Reply Latest reply on May 25, 2020 4:45 PM by jariola

    Import Datapump from 19c into XE18c

    Matthias E.

      Hello,

      i try to import a datapump, exported from 19c, into 18cXE.

      I always get the eroor ORA-39002

       

      The Export Command :  "SYSTEM"."GTH_GEWERBE_EXP_JOB":  system/******** DUMPFILE=GTH_GEWERBE.dmp SCHEMAS=(GTH_GEWERBE) DIRECTORY=DATAPUMP_EXPORT LOGFILE=GTH_GEWERBE_exp.log JOB_NAME=GTH_GEWERBE_exp_job VERSION=18.0

      The Import Command:  IMPDP system/*******@KOMVOR   SCHEMAS=(GTH_GEWERBE) DUMPFILE=GTH_GEWERBE.DMP LOGFILE=GTH_GEWERBE.log  DIRECTORY=IMP_DIR JOB_NAME=GTH_GEWERBE_job 

       

      IMPORT LOG :

      Import: Release 18.0.0.0.0 - Production on Do Apr 23 07:26:51 2020

      Version 18.4.0.0.0

       

      Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

      ;;;

      Angemeldet bei: Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production

      Mastertabelle "SYSTEM"."GTH_GEWERBE_JOB" erfolgreich geladen/entladen

      Job "SYSTEM"."GTH_GEWERBE_JOB" erfolgreich um Do Apr 23 07:26:54 2020 elapsed 0 00:00:01 abgeschlossen

      Job "SYSTEM"."GTH_GEWERBE_JOB" erfolgreich um Do Apr 23 07:26:54 2020 elapsed 0 00:00:01 abgeschlossen

       

      Compatible Parameter in 18cXE is : "18.0.0"

      Grants of the DIRECTORY's are correct.

       

      Datapump Import from "older" Versions  like 12.1. ....  are succesfull.

       

      Does anyone have a similar problem or suggested solution.

       

      MfG

      Matthias

       

      Nachricht geändert durch Matthias E. prpblem ist the "DST_PRIMARY_TT_VERSION';" parameter. Why ? When the DST_PRIMARY_TT_VERSION' ist set to 32 it works. MfG Matthias