锐客网

  1. 首页 > 睿知 > it技术 > >

oracle ORA-20011: Approximate NDV failed: ORA-29913: error in executing ODCIEXTTABLEOPEN callout(示例代

IT知识executingFailed:

登山则情满于山，观海则意溢于海。这篇文章主要讲述oracle ORA-20011: Approximate NDV failed: ORA-29913: error in executing ODCIEXTTABLEOPEN callout(示例代相关的知识，希望能为你提供帮助。
 
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$%‘;
【oracle ORA-20011: Approximate NDV failed: ORA-29913: error in executing ODCIEXTTABLEOPEN callout(示例代】  ---查询结果
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 1,2
---删除---原因是导出有 LOB
drop table SYS.ET$032682FB0001 purge;
   
---其他相关链接
https://blog.csdn.net/www_xue_xi/article/details/79031702
 

























    推荐阅读


    上一篇：Xamarin.Android 使用SoundPool进行音频播放

    下一篇：Android的消息机制Handler