• 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$%';

     ---查询结果

    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

  • 相关阅读:
    Android Studio使用
    VS.NET发送会议邮件程序原码
    C#中渐变色的代码实例,用于自绘菜单
    VS.NET获取某年某月的天数
    AJAX原理简要说明及实例
    ASP.NET下增加定时器功能
    VS.NET发送普通邮件原码
    保存xml到server实例
    VS.NET通过OUTLOOK发邮件
    利用IE打印的一点实例代码
  • 原文地址:https://www.cnblogs.com/ss-33/p/9171674.html
Copyright © 2020-2023  润新知