The Problem: Data Pump Import Fails with Date Format Error You’re running a Data Pump import and it crashes with date format errors like ‘1998-01-01 00:00:00′. You try setting export NLS_DATE_FORMAT=’YYYY-MM-DD HH24:MI:SS’ in your shell, but the import still fails. Error you’re seeing: This happens because Data Pump doesn’t always respect environment-level NLS settings, especially Read more about How to Export NLS_DATE_FORMAT in Oracle: Data Pump Import Date Format Fix[…]