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

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:

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

This case can be tackled in 2 ways.

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 face with some difficulties or have any additional questions, feel free to mail us: support@ispirer.com



More about Ispirer Systems