.bat文件怎么转换成linux的.sh文件
sqlldr rainbow/"public"@orc10g
control=\ftp_rainbow\synCtl\VIEW_CUST_DOCTOR2HOSPITAL.ctl
log=\ftp_rainbow\synCtl\VIEW_CUST_DOCTOR2HOSPITALlog.txt bad=\ftp_rainbow\synCtl\VIEW_CUST_DOCTOR2HOSPITALbad.txt发在linux论坛没人理,,,oracle里有达人给看看~~~~ 接触过的给点例子什么的,谢谢了
sqlldr rainbow/"public"@orc10g
control=\ftp_rainbow\synCtl\VIEW_CUST_DOCTOR2HOSPITAL.ctl
log=\ftp_rainbow\synCtl\VIEW_CUST_DOCTOR2HOSPITALlog.txt bad=\ftp_rainbow\synCtl\VIEW_CUST_DOCTOR2HOSPITALbad.txt发在linux论坛没人理,,,oracle里有达人给看看~~~~ 接触过的给点例子什么的,谢谢了
linux-->"/"
windows-->"\"
#!/bin/bash
sqlldr userid=rainbow/"public"@orc10g
control=/XXX/CCC/VIEW_CUST_DOCTOR2HOSPITAL
log=/XXX/CCC/VIEW_CUST_DOCTOR2HOSPITALlog.txt
bad=/XXX/CCC/VIEW_CUST_DOCTOR2HOSPITALbad.txt
#!/bin/bash
sqlldr userid=rainbow/public@orc10g
control=/XXX/CCC/VIEW_CUST_DOCTOR2HOSPITAL
log=/XXX/CCC/VIEW_CUST_DOCTOR2HOSPITALlog.txt
bad=/XXX/CCC/VIEW_CUST_DOCTOR2HOSPITALbad.txt
[root@localhost ~]# sh test.sh-----------报错说第一行 command no found
#!/bin/bash
export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
export ORACLE_SID=XXXX
$ORACLE_HOME/bin/sqlldr userid=rainbow/public@orc10g log=/XXX/CCC/VIEW_CUST_DOCTOR2HOSPITALlog.txt bad=/XXX/CCC/VIEW_CUST_DOCTOR2HOSPITALbad.txt
Perl code#!/bin/bash
export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
export ORACLE_SID=XXXX
$ORACLE_HOME/bin/sqlldr userid=rainbow/public@orc10g log=/XXX/CCC/VIEW_CUST_DOCTOR2HOSPITALlog.txt bad=/XXX/CCC/VIEW_CUST_DOCTOR2HOSPITALbad.txtbin/sqlldr no surch file~~~~~
export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1 不能照抄的.
改为你ORACLE的安装路径.
还有export ORACLE_SID=XXXX 这句。
vi /etc/crontab
30 0 * * * /home/your_login/bin/java_program
写完后怎么保存退出~~~
export ORACLE_HOME=/user/app/oracle/product/10.2/dba
export ORACLE_SID=orcl10g
$ORACLE_HOME/bin/sqlldr userid=rainbow/public@orc10g log=/XXX/CCC/VIEW_CUST_DOCTOR2HOSPITALlog.txt bad=/XXX/CCC/VIEW_CUST_DOCTOR2HOSPITALbad.txt bin/sqlldr no surch file~~~~~是# sh a.sh 这么测试吧~~
export ORACLE_HOME=/opt/oracle/product/10.2/bin
export ORACLE_SID=orcl10g
export ORACLE_SID=orcl10g
export ORACLE_SID=orcl10g
export ORACLE_SID=orcl10g
$ORACLE_HOME/bin/sqlldr .....
export ORACLE_HOME=/opt/ora10/product/10.2/
export ORACLE_SID=orcl10g
/opt/ora10/product/10.2/bin/sqlldr userid=rainbow....如果还是no such file,那就是权限问题了。你执行该命令的用户没权限读这个目录。
然后先试着执行sqlldr看有什么问题没有