DBMS_STATS: GATHER_STATS_JOB encountered errors.  Check the trace file.
Errors in file /desdb_j000_26964.trc:
ORA-20011: Approximate NDV failed: ORA-29913: error in executing ODCIEXTTABLEOPEN callout
KUP-11024: This external table can only be accessed from within a Data Pump job.

Error analysis：
The external table is not deleted normally，There is still information left in the data dictionary，The table does not actually exist.
An error is reported when the database runs the collect statistics job to collect these external tables.

Solution:

1. Find the object starting with ET：

select owner,
       object_name,
       object_type,
       status,
       to_char(created, 'yyyy-mm-dd hh24:mi:ss') created,
       to_char(last_ddl_time, 'yyyy-mm-dd hh24:mi:ss') last_ddl_time
  from dba_objects
 where object_name like 'ET$%';

2. Confirm that it belongs to the external table generated by dump

select owner,table_name,default_directory_name,access_type from dba_external_tables order by 1,2;

3. Delete

drop table SYSTEM.ET$02D805830001;

drop table SYSTEM.ET$03B700030001;

Read More:

• [Solved] Worker 1 failed executing transaction ‘ANONYMOUS‘ at master log mall-mysql-bin.000001, end_log_pos
• Dbeaver Import SQL File Error: Error executing process Process failed (exit code = 1). See error log. Process failed (exit code = 1). See error log.
• Elasticsearch imports MySQL data Error when executing the bin/logstash – f command
• linux mysql ERROR 1820 (HY000): You must SET PASSWORD before executing this statement
• [Solved] FATAL ERROR: please install the following Perl modules before executing /application/mysql/scripts/mysql_install_db: Data::Dumper
• [Solved] Error in MySQL installation in Linux: failed dependencies xxxxx
• Error 1406 (22001) in MySQL: data too long for column (Fixed)
• postgresql-Database query problem-ERROR: column “t.domainid“ must appear in the GROUP BY clause or be used in an a
• Introduction to Relational Databases in SQL
• [Solved] ORA-04063: package body “SYS.DBMS_DATAPUMP“ has errors
• [ERROR] [FATAL] InnoDB: Table flags are 0 in the data dictionary but the flags in file ./ibdata
• MySQL Error: [ERROR] [FATAL] InnoDB: Table flags are 0 in the data dictionary but the flags in file
• Error creating foreign key in MySQL: 1215 cannot add the foreign key constraint
• Linux Error: [ERROR] –initialize specified but the data directory has files in it. Aborting.
• [Solved] ERROR 1054 (42S22): Unknown column ‘password‘ in ‘field list‘
• [Solved] Daily further: database error: unknown column ‘model’ in ‘field list‘
• [Solved] there are special symbols in the initial password for installing MySQL in Hadoop, and an error is reported
• [Solved] ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregate
• Cannot resolve classpath entry: e://jar/mysql-connector-java-5.1.17-bin mybatis error in reverse engineering
• Problems in connecting mysql8.0 in IDEA [How to Solve]