ORA-20011 ORA-29913 KUP-11024 GATHER_TABLE_STATS
--alter 日志
Sat Mar 30 22:01:08 2019
DBMS_STATS: GATHER_STATS_JOB encountered errors. Check the trace file.
Errors in file /u01/app/oracle/diag/rdbms/bapdb/db2/trace/db2_j001_28934.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.
ORA-20011 ORA-29913 KUP-11024
--trace 文件
[oracle@db2 trace]$ more /u01/app/oracle/diag/rdbms/bapdb/db2/trace/db2_j001_28934.trc
Trace file /u01/app/oracle/diag/rdbms/bapdb/db2/trace/db2_j001_28934.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
ORACLE_HOME = /u01/app/oracle/11.2.0/db_1
System name: Linux
Node name: db2
Release: 3.8.13-68.3.4.el6uek.x86_64
Version: #2 SMP Tue Jul 14 15:03:36 PDT 2015
Machine: x86_64
Instance name: db2
Redo thread mounted by this instance: 2
Oracle process number: 140
Unix process pid: 28934, image: oracle@db2 (J001)
*** 2019-03-30 22:01:08.506
*** SESSION ID:(6788.22093) 2019-03-30 22:01:08.506
*** CLIENT ID:() 2019-03-30 22:01:08.506
*** SERVICE NAME:(SYS$USERS) 2019-03-30 22:01:08.506
*** MODULE NAME:(DBMS_SCHEDULER) 2019-03-30 22:01:08.506
*** ACTION NAME:(ORA$AT_OS_OPT_SY_32713) 2019-03-30 22:01:08.506
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.
*** 2019-03-30 22:01:08.506
DBMS_STATS: GATHER_STATS_JOB: GATHER_TABLE_STATS('"SYS"','"ET$1F79F0570001"','""', ...)
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.
[oracle@db2 trace]$
--MOS 文章---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$%'
1 SYS ET$1F79F0570001 TABLE VALID 29-mar-2019 03:49:00 29-mar-2019 03:49:00
select owner, TABLE_NAME, DEFAULT_DIRECTORY_NAME, ACCESS_TYPE
from dba_external_tables
order by 1,2
1 SYS ET$1F79F0570001 EXP_SHENGCHAN CLOB
22:19:35 SYS@db2(db2)> select count(1) from SYS.ET$1F79F0570001;
select count(1) from SYS.ET$1F79F0570001
*
ERROR at line 1:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
KUP-11024: This external table can only be accessed from within a Data Pump
job.
drop table SYS.ET$1F79F0570001 purge;
22:20:02 SYS@db2(db2)> drop table SYS.ET$1F79F0570001 purge;
Table dropped.
22:21:55 SYS@db2(db2)>
最新文章
- 安全协议系列(四)----SSL与TLS
- markdown 语法测试
- android 之 surfaceView和普通View的重绘使用
- 重温WCF之消息拦截与篡改(八)
- STM32 flash 内存分布介绍
- 2014年最大福利:185个Google排名因素!免费电子书下载
- 找第k大的数
- MVC开发Markdown编辑器(2)
- kindeditor在JavaWeb中的应用
- Projected Coordinate Systems
- FullPage.js全屏滚动插件的配置项、方法和回调函数
- BZOJ 1603: [Usaco2008 Oct]打谷机
- 共通css初次尝试
- ASP.NET MVC Autofac依赖注入的一点小心得(包含特性注入)
- bzoj 3331: [BeiJing2013]压力
- 跨域问题jsonp
- 简单探讨 javascript 闭包
- EventBus VS Spring Event
- JAVA Swing 改变标题栏左上角默认咖啡图标
- 第30月第6天 git log
热门文章
- js 格式化数字(每三位加逗号)
- webpack+vue+vueRouter模块化构建完整项目实例详细步骤-入门篇
- 自定义控件详解(六):Paint 画笔MaskFilter过滤
- Keystone, Start, Failed to Load Bson
- XBanner的简单使用轮播
- 【爬虫】在使用xpath时,排除指定标签
- 微软语音引擎 TTS 最基本使用
- Wu反走样算法绘制直线段
- (网页)jQueryAJAXtimeout超时问题详解(转)
- iOS 10.3下解决Fiddler代理抓包ssl证书信任问题