Configuring the Oracle Data Export tool under Linux SQLULDR2

First, download tool:

Open http://www.anysql.net/on its right to find SQLULDR2, then click:

Second, the download after decompression, there are various corresponding versions, we choose linux64 bit:

Third, put it in the Linux directory you want to execute, modify the $HOME directory. Bash_profile Add the following environment variables:

Export ld_library_path= $ORACLE _home/bin: $ORACLE _home/lib:/lib:/usr/lib

Then use the./sqluldr2_linux64_10204.bin plus the corresponding parameters to execute it.

Execute the./sqluldr2_linux64_10204.bin to see its parameter description:

[[email protected] ~]$./sqluldr2_linux64_10204.bin sql*unloader:fast Oracle Text unloader (GZIP, Parallel), Release 4.0.1 (@) Copyright Lou fangxin (anysql.net) 2004-2010, All rights reserved. USAGE:SQLULDR2 Keyword=value [, Keyword=value,...]    Valid keywords:user = username/[email protected] sql = SQL file name query = SELECT statement Field = Separator string between fields record = separator string between records rows = Print progress for every giv En rows (default, 1000000) file = output file name (default:uldrdata.txt) log = log file name, prefix with + t o Append mode fast = Auto Tuning the session level parameters (YES) Text = output type (MYSQL, CSV, Mysqlins, ORA   Cleins, 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 

Let's take a look at the example:

1.

./sqluldr2_linux64_10204.bin user=c# #scott/[email protected] query= "SELECT * from emp" file= "Emp.txt"

2.

./sqluldr2_linux64_10204.bin user=c# #scott/scott alter= "DISABLE PARALLEL QUERY;" Sql=sql/n3.sql Charset=al32utf8 record=0x0d0x0a File=emp.csv

3.

./sqluldr2_linux64_10204.bin Parfile=parfiles/scott query= "SELECT * from emp" File=/home/yaokangjun/emp.txt

Where Parfile=parfiles/scott is the parfiles profile for its current directory, Scott, for example, Scott:

user=c# #scott/[email protected]charset=zhs16gbkfield=0x1frecord=0x0d0x0aalter=set nls_date_format= ' Yyyymmddhh24miss ';

Configuring the Oracle Data Export tool under Linux SQLULDR2