Search

Top 60 Oracle Blogs

Recent comments

Home

time zone file

Data Pump Between Database Versions : It’s not just about the VERSION parameter! (Time Zone Files)

Submitted by oraclebase on Wed, 2020-02-19 10:40

I was doing a small “quick” data transfer between two servers. The source was 19c and the destination was 18c, so I used the VERSION parameter during the export.

expdp … version=18 directory=…

The export went fine, but when I started the import I immediately got this error.

ORA-39002: invalid operation

A little Googling and I came across MOS Doc ID 2482971.1. In short, the time zone file was different between the two databases.