Ociuldr is a good utility for text unloading, and many people are running it, to avoid compatibilities. I named the new version of text unloading utility as SQL*UnLoader (sqluldr), new version is 25% faster than the old version.
SQL*UnLoader (sqluldr) is the name I prefer used for text unloading utility, due to the old version is not fast enough, I keep this name until the new version's performance testing, but now the speed is acceptable for the new name.
Following is the new version command line help.
SQL*UnLoader: Fast Oracle Text Unloader Release 3.0.0
(@) Copyright Lou Fangxin 2004/2008, all rights reserved.
Usage: SQLULDR keyword=value [,keyword=value,...]
Valid Keywords:
user = username/password@tnsname
sql = SQL file name
query = select statement
field = seperator string between fields
record = seperator string between records
head = print row header(Yes|No)
file = output file name(default: uldrdata.txt)
read = set DB_FILE_MULTIBLOCK_READ_COUNT at session level
sort = set SORT_AREA_SIZE at session level (UNIT:MB)
hash = set HASH_AREA_SIZE at session level (UNIT:MB)
serial = set _serial_direct_read to TRUE at session level
trace = set event 10046 to given level at session level
table = table name in the sqlldr control file
mode = sqlldr option, INSERT or APPEND or REPLACE or TRUNCATE
log = log file name, prefix with + to append mode
long = maximum long field size
array = array fetch size
buffer = sqlldr READSIZE and BINDSIZE, default 16 (MB)
width = customized max column width (w1:w2:...)
for field and record, you can use '0x' to specify hex character code,
\r=0x0d \n=0x0a |=0x7c ,=0x2c \t=0x09
You can download the sqlldr windows version, but just for personal purpose, you will be charged for comercial purpose, the newer source code is not avaiable now. But the source code of ociuldr is still available.
A new command line option "width" was intorduced to customize the column width for fixed length text file.
sqluldr scott/tiger sql=emp.sql width=5:20:20 ...
If the performance of old version is enough, no need to upgrade to sqludr. If you are extracting huge data volumn for data warehouse, search engine, or archive history data in text format, you may choose to upgrade to newer version.