ORA-56935: existing datapump jobs are using a different version of time zone data file
Hello,
I have upgraded my oracle 12c(12.1.0.2) to 12.2.0.1 (Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production)
Unfortunately i still have problem with this bug described here DataPump Import Fails With Errors ORA-39097 ORA-39065 ORA-56935 ( Doc ID 1307959.1 )
My compatible is still set to:
------------------------------------ ----------- -----------
compatible string 12.1.0.0.0
How i can resolve this issue? Should i upgrade this compatible param? Thanks for any ideas...
Following message output:
Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
[ 12:05:03 ] Data Pump Import of QA_DA2017_951O schema
[ 12:05:03 ] executing: 'impdp system/oracle@PLORA12/ORCL directory=DPDUMP_DEST_DIR SCHEMAS=FLX962M remap_schema=FLX962M:QA_DA2017_951O remap_tablespace=FlexNet:QA_DA2017_951O dumpfile=FLX962M_ORA.dmp logfile=IMP_QA_DA2017_951O.log exclude=statistics,user exclude=type:\IN ('TNUMBERSTABLE', 'TSTRINGTABLE', 'PAIR', 'PAIRS')\ transform=OID:n metrics=y JOB_NAME=QA_DA2017_951O'