Hi,


Ever since I have upgraded my database from 11.2.0.2 to 11.2.0.4 I started seeing these errors in my alert log:
Sat Dec 10 06:00:12 2016
DBMS_STATS: GATHER_STATS_JOB encountered errors. Check the trace file.
Errors in file D:\APP\ORACLE\diag\rdbms\v3prod\v3prod\trace\v3prod_j003_11220.trc:
ORA-20011: Approximate NDV failed: ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-04040: file Actuarial_Export_For_Available_Money_Member_20120828_1348.txt in IMPORT_EXPORT_DIRECTORY not found
Sat Dec 10 06:07:10 2016

I found this document on your site: Doc ID 1507089.1. Per this document I had collected this information:

SQL> select * from dba_external_tables where table_name = 'table_name';
no rows selected
SQL> select * from DBA_EXTERNAL_LOCATIONS;
OWNER TABLE_NAME
------------------------------ ------------------------------
LOCATION
---------------------------------------------------------------------------
DIR DIRECTORY_NAME
--- ------------------------------
BENDEV ACTU_EXT
Actuarial_Export_For_Available_Money_Member_20120828_1348.txt
SYS IMPORT_EXPORT_DIRECTORY






Thanks in Advance,