Shulou(Shulou.com)05/31 Report--

This article shows you the oracle expdp homework appearance error report ORA-20011&KUP-11024&ORA-29913 how to do, the content is concise and easy to understand, absolutely can make your eyes bright, through the detailed introduction of this article, I hope you can get something.

Oracle database alarm ORA-20011&KUP-11024&ORA-29913

The related processing is as follows:

Operating system version: rhel 2.6.39-400.17.1.el6uek.x86_64

Set pagesize 2000

Col owner form a30

Col created form a25

Col last_ddl_time form a25

Col object_name form a30

Col object_type form a25

SQL > select OWNER,OBJECT_NAME,OBJECT_TYPE, status

2 to_char (CREATED,'dd-mon-yyyy hh34:mi:ss') created

3 to_char (LAST_DDL_TIME, 'dd-mon-yyyy hh34:mi:ss') last_ddl_time

4 from dba_objects

5 where object_name like 'ET$%'

OWNER OBJECT_NAME OBJECT_TYPE STATUS CREATED LAST_DDL_TIME

--

EXPDP ET$01D400370001 TABLE VALID 09-oct-2015 23:11:41 09-oct-2015 23:11:41

EXPDP ET$01D3186F0001 TABLE VALID 18-dec-2015 02:20:04 18-dec-2015 02:20:04

EXPDP ET$01C303530001 TABLE VALID 15-mar-2015 00:45:46 15-mar-2015 00:45:46

EXPDP ET$01B7017F0001 TABLE VALID 15-mar-2015 00:42:03 15-mar-2015 00:42:03

EXPDP ET$01982C090001 TABLE VALID 08-oct-2015 23:51:06 08-oct-2015 23:51:06

EXPDP ET$00251AEF0001 TABLE VALID 29-dec-2015 00:50:20 29-dec-2015 00:50:20

6 rows selected.

SQL > select owner, TABLE_NAME, DEFAULT_DIRECTORY_NAME, ACCESS_TYPE

From dba_external_tables

Order by 1,2

OWNER TABLE_NAME DEFAULT_DIRECTORY_NAME ACCESS_

EXPDP ET$00251AEF0001 EXPDATA CLOB

EXPDP ET$01982C090001 EXPDATA CLOB

EXPDP ET$01B7017F0001 EXPDATA CLOB

EXPDP ET$01C303530001 EXPDATA CLOB

EXPDP ET$01D3186F0001 EXPDATA CLOB

EXPDP ET$01D400370001 EXPDATA CLOB

SYS ALERT_LOG_VIEW BDUMP CLOB

-- query the external table and report the same error as the alert log

SQL > select count (*) from EXPDP.ET$00251AEF0001

Select count (*) from EXPDP.ET$00251AEF0001

*

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.

SQL >

-- View external table definitions

SQL > desc ET$00251AEF0001

ERROR:

ORA-04043: object ET$00251AEF0001 does not exist

3. Clean up DataPump jobs.

SQL > select 'drop table' | | owner | |'. | | object_name | | 'purge;' from dba_objects where object_name like 'ET$%'

'DROPTABLE' | | OWNER | |'. | | OBJECT_NAME | | 'PURGE;'

Drop table EXPDP.ET$01D400370001 purge

Drop table EXPDP.ET$01D3186F0001 purge

Drop table EXPDP.ET$01C303530001 purge

Drop table EXPDP.ET$01B7017F0001 purge

Drop table EXPDP.ET$01982C090001 purge

Drop table EXPDP.ET$00251AEF0001 purge

6 rows selected.

SQL > drop table EXPDP.ET$01D400370001 purge

Drop table EXPDP.ET$01D3186F0001 purge

Drop table EXPDP.ET$01C303530001 purge

Drop table EXPDP.ET$01B7017F0001 purge

Drop table EXPDP.ET$01982C090001 purge

Drop table EXPDP.ET$00251AEF0001 purge

Table dropped.

SQL >

Table dropped.

SQL >

Table dropped.

SQL >

Table dropped.

SQL >

Table dropped.

SQL >

Table dropped.

As can be seen from the above information, the external table of the data pump was generated in March and October 2015 respectively.

The equipment has been reinstalled and the computer room has been relocated:

Guess: maybe at that time, the database was reinstalled and the computer room was relocated, the database used data pump backup and the data pump job did not exit successfully, resulting in the data pump.

The residual external table of the job affects the collection of database statistics, and the processing method is to delete the residual external table of the data pump job. Personally, I think it's strange.

The strange thing is that the external table entity of the data pump job no longer exists, the DDL definition no longer exists, but the external indication exists, which should be a database dictionary.

The information is wrong.

The above content is the oracle expdp homework appearance error report ORA-20011&KUP-11024&ORA-29913 what to do, have you learned the knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.