KUP-11024: This external table can only be accessed from within a Data Pump job. [message #637166] |
Tue, 12 May 2015 03:16 |
OlafCologne
Messages: 11 Registered: September 2008 Location: Cologne
|
Junior Member |
|
|
Hello,
i have a error-message in the ora_alert:
----
DBMS_STATS: GATHER_STATS_JOB encountered errors. Check the trace file.
Errors in file C:\ORACLE\diag\rdbms\whms\whms\trace\whms_j001_16972.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.
---
A data_pump job is not running. The result of a SQL-Check is:
OWNER_NAME JOB_NAME OPERATION JOB MODE STATE ATTACHED_SESSIONS
--------------------------------------------------------------------------------- ------------------------------
SYSTEM SYS_IMPORT_TABLE_01 IMPORT TABLE NOT RUNNING 0
OWNER OBJECT_NAME OBJECT_TYPE STATUS CREATED LAST_DDL_TIME
------------------------------ -------------------------------------------------- ------------------------------
SYSTEM ET$009598E90001 TABLE VALID 24-jan-2015 14:33:15 24-jan-2015 14:33:15
SYSTEM ET$00FF059B0001 TABLE VALID 24-jan-2015 13:00:36 24-jan-2015 13:00:36
OWNER TABLE_NAME DEFAULT_DIRECTORY_NAME ACCESS_TYPE
------------------------------ ------------------------------ ------------------------------ -----------
SYSTEM ET$00FF059B0001 DATA_PUMP_DIR CLOB
SYSTEM ET$009598E90001 DATA_PUMP_DIR CLOB
How do I resolve the error? Is it enough the tables to delete?
Thanks!
|
|
|
|
Re: KUP-11024: This external table can only be accessed from within a Data Pump job. [message #637561 is a reply to message #637169] |
Wed, 20 May 2015 03:38 |
OlafCologne
Messages: 11 Registered: September 2008 Location: Cologne
|
Junior Member |
|
|
Excuse for my late answer. Excuse me, I not always have accessed the database, because it is external.
1/
It is an entry in ora_alert.log I cannot say what is for a job which causes the mistake.
2/
***********************************************************************
Fri May 01 23:00:11 2015
DBMS_STATS: GATHER_STATS_JOB encountered errors. Check the trace file.
Errors in file C:\ORACLE\diag\rdbms\whms\whms\trace\whms_j002_2592.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.
***********************************************************************
Fatal NI connect error 12170.
VERSION INFORMATION:
TNS for 64-bit Windows: Version 11.2.0.4.0 - Production
Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.4.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.4.0 - Production
Time: 01-MAI-2015 00:18:59
Tracing not turned on.
Tns error struct:
ns main err code: 12535
TNS-12535: TNS: Timeout für Vorgang
ns secondary err code: 12560
nt main err code: 505
TNS-00505: Timeout bei Vorgang
nt secondary err code: 60
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.35.81)(PORT=51779))
***********************************************************************
3/Oracle Version
Version 11.2.0.4.0
4/
SELECT owner_name, job_name, operation, job_mode, state, attached_sessions
FROM dba_datapump_jobs
WHERE job_name NOT LIKE 'BIN$%'
ORDER BY 1,2;
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$%';
SELECT owner, TABLE_NAME, DEFAULT_DIRECTORY_NAME, ACCESS_TYPE
FROM dba_external_tables;
5/Contents of the Tracefile
Trace file C:\ORACLE\diag\rdbms\whms\whms\trace\whms_j002_3712.trc
Oracle Database 11g Release 11.2.0.4.0 - 64bit Production
Windows NT Version V6.1 Service Pack 1
CPU : 12 - type 8664, 6 Physical Cores
Process Affinity : 0x0x0000000000000000
Memory (Avail/Total): Ph:8717M/16335M, Ph+PgF:22538M/32668M
Instance name: whms
Redo thread mounted by this instance: 1
Oracle process number: 47
Windows thread id: 3712, image: ORACLE.EXE (J002)
*** 2015-05-02 07:00:12.294
*** SESSION ID:(390.26389) 2015-05-02 07:00:12.294
*** CLIENT ID:() 2015-05-02 07:00:12.294
*** SERVICE NAME:(SYS$USERS) 2015-05-02 07:00:12.294
*** MODULE NAME:(DBMS_SCHEDULER) 2015-05-02 07:00:12.294
*** ACTION NAME:(ORA$AT_OS_OPT_SY_11323) 2015-05-02 07:00:12.294
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.
*** 2015-05-02 07:00:12.294
DBMS_STATS: GATHER_STATS_JOB: GATHER_TABLE_STATS('"SYSTEM"','"ET$00FF059B0001"','""', ...)
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.
*** 2015-05-02 07:00:12.325
DBMS_STATS: GATHER_STATS_JOB: GATHER_TABLE_STATS('"SYSTEM"','"ET$009598E90001"','""', ...)
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.
|
|
|