今天试了一下sqluldr2 导出数据,果然是超级快。
sqluldr2_linux32_10204.bin
sqluldr2_linux64_10204.bin
sqluldr2.exe
sqluldr264.exe
第一次执行报错:
[oracle@tora80 backup]$ ./sqluldr2_linux32_10204.bin user=scott/tiger query="select * from t1 where rownum<10001" head=yes file=/home/oracle/x.csv;
./sqluldr2_linux32_10204.bin: error while loading shared libraries: libclntsh.so.10.1: cannot open shared object file: No such file or directory
设置环境变量:
[oracle@tora80 ~]$ vi .bash_profile
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
但是这次导出发现都是乱码
查看一下参数:
[oracle@tora80 ~]$ ./sqluldr2_linux32_10204.bin -help
SQL*UnLoader: Fast Oracle Text Unloader (GZIP, Parallel), Release 4.0.1
(@) Copyright Lou Fangxin (AnySQL.net) 2004 - 2010, all rights reserved.
License: Free for non-commerci