Home » RDBMS Server » Server Utilities » KUP-11024: This external table can only be accessed from within a Data Pump job. (WIN Server 2008 / Oracle 11G)
KUP-11024: This external table can only be accessed from within a Data Pump job. [message #637166] Tue, 12 May 2015 03:16 Go to next message
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 #637169 is a reply to message #637166] Tue, 12 May 2015 03:37 Go to previous messageGo to next message
Michel Cadot
Messages: 66552
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Post
1/ The command you were executing
2/ An abstract of the log larger than the one you posted (the header of the job log, plus 10 lines around the error)
3/ The version of your database (select * from v$version)
4 "The result of a SQL-Check is:" what check? Use SQL*Plus and copy and paste all what you do and get
5/ "Errors in file C:\ORACLE\diag\rdbms\whms\whms\trace\whms_j001_16972.trc:" what is in this file?

Before, Please read How to use [code] tags and make your code easier to read.

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 Go to previous message
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.

Previous Topic: Import /Export from 9i to 12cR2
Next Topic: data migration
Goto Forum:
  


Current Time: Tue Sep 17 03:38:45 CDT 2019