oracle ndv,oracle ORA-20011: Approximate NDV failed: ORA-29913: error in executing ODCIEXTTABLEOPEN ...

Mon Jun 11 21:59:52 2018

LNS: Standby redo logfile selected for thread 2 sequence 132997 for destination LOG_ARCHIVE_DEST_10

Mon Jun 11 21:59:55 2018

Archived Log entry 465126 added for thread 2 sequence 132996 ID 0x92570693 dest 1:

Mon Jun 11 22:00:00 2018

Setting Resource Manager plan SCHEDULER[0x32D9]:DEFAULT_MAINTENANCE_PLAN via scheduler window

Setting Resource Manager plan DEFAULT_MAINTENANCE_PLAN via parameter

Mon Jun 11 22:00:00 2018

Starting background process VKRM

Mon Jun 11 22:00:00 2018

VKRM started with pid=609, OS id=39289

Mon Jun 11 22:00:09 2018

Begin automatic SQL Tuning Advisor run for special tuning task  "SYS_AUTO_SQL_TUNING_TASK"

Mon Jun 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 be accessed from within a Data Pump job.

Mon Jun 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# 10 seq# 132998 mem# 0: +SAS_DATA/bapdb/redo10a.log

Current log# 10 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 can only be 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 external table can only be accessed from within a Data Pump job.

--------support.oracle.com 找到文章 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$%‘;

---查询结果

SYS ET$032682FB0001TABLE 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 1,2

---删除---原因是导出有 LOB

drop table SYS.ET$032682FB0001 purge;

---其他相关链接

https://blog.csdn.net/www_xue_xi/article/details/79031702

原文：https://www.cnblogs.com/ss-33/p/9171674.html