1. make sure that Oracle Client was installed. If not, following this link to install.
2. Download Oracle Database Express Edition (oracle-xe-11.2.0-1.0.x86_64.rpm.zip) from here:
3. extract rpm file from the downloaded file
unzip -d oracle-ex oracle-xe-11.2.0-1.0.x86_64.rpm.zip cd oracle-ex/Disk1 # extract files from rpm package rpm2cpio oracle-xe-11.2.0-1.0.x86_64.rpm | cpio -idmv # copy file sqlldr and folder mesg to local $ORACLE_HOME sudo cp u01/app/oracle/product/11.2.0/xe/bin/sqlldr /usr/lib/oracle/11.2/client64/bin # create fold rdbms/mesg at $ORACLE_HOME sudo mkdir -p /usr/lib/oracle/11.2/client64/rdbms/mesg #then copy files from mesg folder sudo cp u01/app/oracle/product/11.2.0/xe/rdbms/mesg/* /usr/lib/oracle/11.2/client64/rdbms/mesg/4. now you could run sqlldr to batch load data
sqlldr user/pass@//oracle_server:1521/devl control="RXNCONSO.ctl";
No comments:
Post a Comment