Last night the job of statistics has failed. The error is as follows;
DBMS_STATS: GATHER_STATS_JOB encountered errors. Check the trace file.
Errors in file /sibdos/prod/trace/diag/rdbms/sibdos/SIBDOS/trace/sibdos_j000_16132.trc:
ORA-20011: Approximate NDV failed: ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
error opening file /oracle_indexes/sibdos/trace/bdump/ALERT_LOG_16132.log
After researching the topic I see the problem is that there is due to a external table created. in this case the database was migrated a couple of days ago. External table is in a location (path) that no longer exists. The problem is solved by deleting the external table. The following query shows how view external tables we have created.
SELECT OWNER, TABLE_NAME, DEFAULT_DIRECTORY_NAME, ACCESS_TYPE FROM DBA_EXTERNAL_TABLAS ORDER BY 1,2 /
HTH – Antonio NAVARRO