I am having an Oracle problem with a dump import (impdp). The error I get "ORA-39002: invalid operation" has no other information in the logs. Online I find some mention of file permissions, but that doesn't seem to be a problem.

I suspect that a patch that I installed went wonky.

After investigating, I found something that looked odd.

I would think that these queries would essentially return the same.

SELECT * FROM v$timezone_file;
SELECT DBMS_DST.get_latest_timezone_version FROM   dual;  

However, first one results in version 31 and the second one 40.

FILENAME                VERSION     CON_ID
-------------------- ---------- ----------
timezlrg_31.dat              31          0

GET_LATEST_TIMEZONE_VERSION
---------------------------
                         40

Can this be correct? And if not how can I fix it?