ORA-20011 And ORA-29400 Erros executing GATHER_STATS_JOB

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

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s