2012年6月26日星期二

sqluldr2在linux上运用

# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi

# User specific environment and startup programs
         
PATH=$PATH:$HOME/bin
         
export PATH
export ORACLE_SID=orcl
export ORACLE_BASE=/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
export PATH=$ORACLE_HOME/bin:$PATH:$ORACLE_HOME/lib
export NLS_LANG='AMERICAN_AMERICA.ZHS16GBK'
export LD_LIBRARY_PATH=$ORACLE_HOME/lib

[oracle@localhost sqluldr]$ ./sqluldr2_linux64_10204.bin cm_dsa/cm_dsa query=ds_clt_abis_ho field=, file=/oradata/cm_dsadump/ds_clt_abis_ho.csv text=CSV

没有评论:

发表评论