Oracle Ora-20011:approximate NDV failed:ora-29913:error in executing odciexttableopen callout

Mon June 11 21:59:52 2018
Lns:standby Redo logfile selected for thread 2 sequence 132997 for destination log_archive_dest_10
Mon June 11 21:59:55 2018
Archived Log Entry 465126 added for thread 2 sequence 132996 ID 0x92570693 dest 1:
Mon June 11 22:00:00 2018
Setting Resource Manager Plan scheduler[0x32d9]:D Efault_maintenance_plan via SCHEDULER window
Setting Resource Manager plan Default_maintenance_plan via parameter
Mon June 11 22:00:00 2018
Starting background Process VKRM
Mon June 11 22:00:00 2018
VKRM started with pid=609, OS id=39289
Mon June 11 22:00:09 2018
Begin Automatic SQL Tuning Advisor run for special Tuning task "Sys_auto_sql_tuning_task"
Mon June 11 22:00:21 2018
Dbms_stats:gather_stats_job encountered errors. Check the trace file.
Errors in FILE/U01/APP/ORACLE/DIAG/RDBMS/BAPDB/BAPDB2/TRACE/BAPDB2_J001_39449.TRC:
Ora-20011:approximate NDV failed:ora-29913:error in executing odciexttableopen callout
Kup-11024:this External table can only is accessed from within a Data Pump job.
Mon June 11 22:03:38 2018
Lgwr:standby Redo logfile selected for thread 2 sequence 132998 for destination Log_archive_dest_3
Thread 2 advanced to log sequence 132998 (LGWR switch)
Current log# seq# 132998 mem# 0: +sas_data/bapdb/redo10a.log
Current log# seq# 132998 mem# 1: +sas_data/bapdb/redo10b.log

Ora-20011:approximate NDV failed:ora-29913:error in executing odciexttableopen callout kup-11024:this external Table C An is accessed from within a Data Pump job.

2018-06-11 22:00:21.096 DBMS_STATS:GATHER_STATS_JOB:GATHER_TABLE_STATS (' "SYS" ', ' "et$032682fb0001" ', ' "'" ', ...) Dbms_stats:ora-20011:approximate NDV failed:ora-29913:error in executing odciexttableopen callout kup-11024:this exte Rnal table can only is accessed from within a Data Pump job.

--------support.oracle.com found article 1274653.1

Select Owner,object_name,object_type, Status, To_char (CREATED, ' dd-mon-yyyy hh24:mi:ss ') CREATED, To_char (last_ddl_ Time, ' dd-mon-yyyy hh24:mi:ss ') Last_ddl_time from dba_objects where object_name like ' et$% ';

---query results

SYS et$032682fb0001 TABLE VALID 07-jun-2018 17:30:39 07-jun-2018 17:30:39

Select owner, TABLE_NAME, Default_directory_name, Access_type from Dba_external_tables order by

---reason for---removal is that LOB is exported

drop table sys.et$032682fb0001 Purge;

---Other RELATED LINKS

79031702

Oracle Ora-20011:approximate NDV failed:ora-29913:error in executing odciexttableopen callout