Forum Discussion

Hemanth's avatar
Hemanth
New Contributor
8 years ago

Oracle Bulk Load - SQLLDR Path Issue

Hi, I am trying to use the Oracle Bulk Load option for inserting the data, currently getting the issue for SQLLDR path. I have provided the path of SQLLDR like this and SQLLDR is available in this ...
Hemanth's avatar
Hemanth
New Contributor
8 years ago

Tried with opening / as /u01/app/oracle/product/12.1.0/dbhome_1/bin/sqlldr this also did not work.

mthirani's avatar
mthirani
Employee
8 years ago

Have you tried using the suggestions in the snap for this field?
Also make sure the ORACLE_HOME, PATH and ORACLE_SID is set appropriately in the plex for oracle. For example:

export ORACLE_HOME=“/u01/app/oracle/product/11.2.0/xe”
export ORACLE_SID=“XE”
export PATH=$ORACLE_HOME/bin:$PATH