Ispirer Ispirer
 


Ispirer Home Page Ispirer SQLWays Product Page - Oracle Migration Request SQLWays

Data Was Not Loaded (SQLLDR Bug with oranfsodm12.dll)

Symptoms

After running the import process into the Oracle database in the import log file there was no information about the number of loaded rows, and additional .log files with the information about the data load process were not generated in the export directory.

Also when running the -help command with sqlldr utility.

 sqlldr -help

You see the screenshot below:

Cause

This issue appears with Oracle Database Client (12.1.0.2.0), the because there is no oranfsodm12.dll in the BIN directory (directory on the local machine, where all the Oracle utilities are located).

Solution

There are 2 ways of resolving such a case.

Copy the File

In the BIN directory, copy the oraodm12.dll file and renaming it to oranfsodm12.dll. And it should solve the issue.

Reinstall your Oracle Client

The other way is to reinstall your Oracle client.

After the installation process this issue should be fixed.



If you will face with some difficulties or will have any additional questions, please feel free to mail us: support@ispirer.com


Ispirer Home Page Ispirer SQLWays Product Page - Oracle Migration Request SQLWays

sqlways/troubleshooting-guide/oracle/import/data-not-loaded.txt · Last modified: July 24, 2018, 10:00:03 AM by alexandr.kirpichny
 
© 1999-2019, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement