ORA-20011 ORA-29913 KUP-11024

遇到错误

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.

 

--原来是曾经expdp任务没有正常清理后台表，用下面的语句找到对应的表，drop掉即可。

select owner, TABLE_NAME, DEFAULT_DIRECTORY_NAME,ACCESS_TYPE from dba_external_tables;

1    SYS    ET$0AE115750001    KEVIN_TEMP    CLOB
2    SYS    ET$0B4111DD0001    KEVIN_TEMP    CLOB

--使用下面的语句可以进一步确认表创建的时间等信息

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

 

--将上述查询的表drop掉

SQL> drop table ET$0AE115750001 ;

Table dropped

SQL> drop table ET$0B4111DD0001 ;

Table dropped