The Problem: Data Pump Import Fails with Date Format Error Setting NLS_DATE_FORMAT before impdp is the standard fix for data pump import date format error i.e. ORA-01843 and ORA-01861 during Data Pump imports — but it doesn’t always work. Data Pump spawns its own worker processes and doesn’t always inherit the OS-level environment. When the Read more about How to Export NLS_DATE_FORMAT in Oracle: Data Pump Import Date Format Fix[…]