#切回root用户[oracle@oradb bin]$ exit[root@oradb ~]# chown -R oracle.oinstall sqluldr2.bin [root@oradb ~]# su - oracle[oracle@oradb ~]$ cd /usr/local/oracle/product/11.2.0/bin/[oracle@oradb bin]$ ldd sqluldr2.bin
linux-vdso.so.1 => (0x00007ffd840ae000)
libclntsh.so.10.1 => /usr/local/oracle/product/11.2.0/lib/libclntsh.so.10.1 (0x00007f8b751e6000)
libc.so.6 => /lib64/libc.so.6 (0x00007f8b74e19000)
libnnz11.so => /usr/local/oracle/product/11.2.0/lib/libnnz11.so (0x00007f8b74a51000)
libdl.so.2 => /lib64/libdl.so.2 (0x00007f8b7484d000)
libm.so.6 => /lib64/libm.so.6 (0x00007f8b7454b000)
libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f8b7432f000)
libnsl.so.1 => /lib64/libnsl.so.1 (0x00007f8b74115000)
libaio.so.1 => /lib64/libaio.so.1 (0x00007f8b73f13000)/lib64/ld-linux-x86-64.so.2 (0x00007f8b77811000)#若出现libclntsh.so.10.1 => not found,则[oracle@oradb bin]$ cd $ORACLE_HOME/lib
[oracle@oradb lib]# sudo ln -s libclntsh.so libclntsh.so.10.1[oracle@oradb bin]$ ./sqluldr2.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-commercial useage,else 100 USD per server.
Usage: SQLULDR2 keyword=value [,keyword=value,...]
Valid Keywords:
user = username/password@tnsname
sql = SQL file name
query = select statement
field = separator string between fields
record = separator string between records
rows = print progress for every given rows (default, 1000000)
file = output file name(default: uldrdata.txt)
log = log file name, prefix with + to append mode
fast = auto tuning the session level parameters(YES)
text = output type(MYSQL, CSV, MYSQLINS, ORACLEINS, FORM, SEARCH).
charset = character set name of the target database.
ncharset= national character set name of the target database.
parfile = read command option from parameter file
for field and record, you can use '0x' to specify hex character code,
\r=0x0d \n=0x0a |=0x7c ,=0x2c, \t=0x09, :=0x3a,#=0x23, "=0x22 '=0x27