Skip to Main Content
  • Questions
  • ORA-29400: data cartridge error -- Windows

Breadcrumb

Dev Live Dev Intro

We are celebrating Developers at AskTOM. We welcome Developers of all levels of experience to join us at our FREE Developer Live events coming in August and September. Just click on the left to register today! If you are brand new to Database Technology, then we also have got you covered. Just click on the right for your comprehensive FREE training program to kick start your Oracle Database Development journey!

Question and Answer

Connor McDonald

Thanks for the question, Hariharan.

Asked: January 27, 2017 - 2:34 pm UTC

Answered by: Connor McDonald - Last updated: August 13, 2020 - 3:05 am UTC

Category: Database - Version: 11.2.0.4

Viewed 10K+ times! This question is

You Asked

Hi,


Ever since I have upgraded my database from 11.2.0.2 to 11.2.0.4 I started seeing these errors in my alert log:
Sat Dec 10 06:00:12 2016
DBMS_STATS: GATHER_STATS_JOB encountered errors. Check the trace file.
Errors in file D:\APP\ORACLE\diag\rdbms\v3prod\v3prod\trace\v3prod_j003_11220.trc:
ORA-20011: Approximate NDV failed: ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-04040: file Actuarial_Export_For_Available_Money_Member_20120828_1348.txt in IMPORT_EXPORT_DIRECTORY not found
Sat Dec 10 06:07:10 2016

I found this document on your site: Doc ID 1507089.1. Per this document I had collected this information:

SQL> select * from dba_external_tables where table_name = 'table_name';
no rows selected
SQL> select * from DBA_EXTERNAL_LOCATIONS;
OWNER TABLE_NAME
------------------------------ ------------------------------
LOCATION
---------------------------------------------------------------------------
DIR DIRECTORY_NAME
--- ------------------------------
BENDEV ACTU_EXT
Actuarial_Export_For_Available_Money_Member_20120828_1348.txt
SYS IMPORT_EXPORT_DIRECTORY






Thanks in Advance,

and we said...

The critical part of the error is this:

KUP-04040: file Actuarial_Export_For_Available_Money_Member_20120828_1348.txt in IMPORT_EXPORT_DIRECTORY not found

We could not find that file in the directory IMPORT_EXPORT_DIRECTORY, or the oracle account did not have sufficient OS permissions to see it.

So we could not collect statistics on it, hence the error.

and you rated our response

  (4 ratings)

Is this answer out of date? If it is, please let us know via a Review

Reviews

January 30, 2017 - 5:20 pm UTC

Reviewer: Hariharan Senthil pandiyan

Hi,

The original file Actuarial_Export_For_Available_Money_Member_20120828_1348.txt was found and placed in the IMPORT_EXPORT_DIRECTORY folder, but it still didn't help and I still get the error.

Thanks,
Connor McDonald

Followup  

January 30, 2017 - 8:15 pm UTC

"We could not find that file in the directory IMPORT_EXPORT_DIRECTORY, or the oracle account did not have sufficient OS permissions to see it. "

January 31, 2017 - 4:22 pm UTC

Reviewer: Hariharan Senthil pandiyan

Thanks

March 10, 2017 - 7:08 pm UTC

Reviewer: kanaka from owings mills, MD USA

Hi Hariharan,

I have the similar issue. How did you resolve it? Please help.

ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-04040: file XXXYYYZZZ.psv in XXX_DATA not found
Connor McDonald

Followup  

March 11, 2017 - 2:02 am UTC

"We could not find that file in the directory IMPORT_EXPORT_DIRECTORY, or the oracle account did not have sufficient OS permissions to see it. "

My Windows XE External Table Solution for ORA-29400: Data Cartridge-Fehler, KUP-04040

August 11, 2020 - 4:06 pm UTC

Reviewer: juergen from Germany

External Table Failure:
ORA-29400: Data Cartridge-Fehler, KUP-04040 ...

After a windows Update ORACLE External Tables don´t work properly.

Now I solve ist to give more Rights to the Oracle-Directory by WINDOWS. Now it works again. The same facht is with LINUX and +777 Riights.

Windows 10 Explorer (öffnen / open) -- > go to the Directory (Eigenschaften / Properties) --> Sicherheit / Security --> Add the Oracle-User or group and set READ/WRITE
Connor McDonald

Followup  

August 13, 2020 - 3:05 am UTC

Thanks for the update.