- 论坛徽章:
- 0
|
接13楼贴
接13楼贴!!!!
如果不用EXPORT等,脚本:
env > env.txt
cd imp-exp
echo "exporting......."
exp system/leadtone@cdmadb PARFILE=exp.cfg OWNER=GEGWWEN > xxx
######以下是个ORACLE命令,XXXX是连接的用户名密码什么的,隐了########
sqlplus xxxx/xxxx@xxxx @./sql/generate-create-seq.sql
echo "export success, importing........"
exit 0
环境变量:
HOSTNAME=localhost.localdomain
PVM_RSH=/usr/bin/rsh
SHELL=/bin/bash
TERM=vt100
HISTSIZE=1000
SSH_CLIENT=192.168.2.54 2244 22
NLS_LANG=AMERICAN
SSH_TTY=/dev/pts/0
USER=oracle
LS_COLORS=no=00:fi=00:di=01;34:ln=01;36:pi=40;33:so=01;35:bd=40;33;01:cd=40;33;01r=01;05;37;41:mi=01;05;37;41:ex=01;32:*.cmd=01;32:*.exe=01;32:*.com=01;32:*.btm=01;32:*.bat=01;32:*.sh=01;32:*.csh=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.gz=01;31:*.bz2=01;31:*.bz=01;31:*.tz=01;31:*.rpm=01;31:*.cpio=01;31:*.jpg=01;35:*.gif=01;35:*.bmp=01;35:*.xbm=01;35:*.xpm=01;35:*.png=01;35:*.tif=01;35:
LD_LIBRARY_PATH=/home/oracle/product/9.2.0/lib:/lib:/usr/lib:/usr/local/lib
ORACLE_SID=cdmadb
PVM_ROOT=/usr/share/pvm3
ORACLE_BASE=/home/oracle
PATH=/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/home/oracle/bin:/home/wanglin/env/jdk15/bin:/home/oracle/product/9.2.0/bin
MAIL=/var/spool/mail/oracle
_=/bin/env
PWD=/home/oracle/CompDB
INPUTRC=/etc/inputrc
LANG=zh_CN.GB18030
LAMHELPFILE=/etc/lam/lam-helpfile
ORACLE_TERM=xterm
SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
HOME=/home/oracle
SHLVL=2
LD_ASSUME_KERNEL=2.4.1
LOGNAME=oracle
SSH_CONNECTION=192.168.2.54 2244 192.168.2.28 22
LESSOPEN=|/usr/bin/lesspipe.sh %s
ORA_NLS33=/home/oracle/product/9.2.0/ocommon/nls/admin/data
ORACLE_HOME=/home/oracle/product/9.2.0
G_BROKEN_FILENAMES=1
用JAVA调用脚本的环境变量
HOSTNAME=localhost.localdomain
PVM_RSH=/usr/bin/rsh
SHELL=/bin/bash
TERM=vt100
HISTSIZE=1000
SSH_CLIENT=192.168.2.54 2244 22
NLS_LANG=AMERICAN
SSH_TTY=/dev/pts/0
USER=oracle
LS_COLORS=no=00:fi=00:di=01;34:ln=01;36:pi=40;33:so=01;35:bd=40;33;01:cd=40;33;01r=01;05;37;41:mi=01;05;37;41:ex=01;32:*.cmd=01;32:*.exe=01;32:*.com=01;32:*.btm=01;32:*.bat=01;32:*.sh=01;32:*.csh=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.gz=01;31:*.bz2=01;31:*.bz=01;31:*.tz=01;31:*.rpm=01;31:*.cpio=01;31:*.jpg=01;35:*.gif=01;35:*.bmp=01;35:*.xbm=01;35:*.xpm=01;35:*.png=01;35:*.tif=01;35:
LD_LIBRARY_PATH=/home/wanglin/env/jdk15/jre/lib/i386/client:/home/wanglin/env/jdk15/jre/lib/i386:/home/wanglin/env/jdk15/jre/../lib/i386:/home/oracle/product/9.2.0/lib:/lib:/usr/lib:/usr/local/lib
ORACLE_SID=cdmadb
PVM_ROOT=/usr/share/pvm3
ORACLE_BASE=/home/oracle
NLSPATH=/usr/dt/lib/nls/msg/%L/%N.cat
PATH=/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/home/oracle/bin:/home/wanglin/env/jdk15/bin:/home/oracle/product/9.2.0/bin
MAIL=/var/spool/mail/oracle
_=/bin/env
PWD=/home/oracle/CompDB
INPUTRC=/etc/inputrc
LANG=zh_CN.GB18030
LAMHELPFILE=/etc/lam/lam-helpfile
XFILESEARCHPATH=/usr/dt/app-defaults/%L/Dt
ORACLE_TERM=xterm
SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
HOME=/home/oracle
SHLVL=2
LD_ASSUME_KERNEL=2.4.1
LOGNAME=oracle
SSH_CONNECTION=192.168.2.54 2244 192.168.2.28 22
LESSOPEN=|/usr/bin/lesspipe.sh %s
ORA_NLS33=/home/oracle/product/9.2.0/ocommon/nls/admin/data
ORACLE_HOME=/home/oracle/product/9.2.0
G_BROKEN_FILENAMES=1 |
|