DBA Tools

Fast Oracle text unload speed with ociuldr by Alibaba

    Free Oracle text unload utility (ociuldr) was used to extract Oracle data from OLTP system and then load them into their OLAP system by alibaba company (Taobao). They get a really fast unload speed these days. 0         rows...

Posted on November 29, 2007 8:00 PM

Choosing right separators when unload (export) rows to text file

    I am moving some data by ociuldr with the following field and record option. ociuldr ... field=0x07 record=0x06 ...     I think it will work well, but actually not, there are rows rejected when loading with sqlldr....

Posted on September 27, 2007 4:13 PM

How to pass parameters to your program in Shell script.

    I wrote some OCI program and compiled them into 32 bit executable on 64 bit Solaris machine. So I need to set the proper Oracle library path to get it work. I wrote a shell script to set...

Posted on September 27, 2007 2:14 PM

The LONG RAW data type support of text unload (export) utility

    Now you can use ociuldr to move data with LONG RAW type. Just the same as LONG type, the "long=" option define the maximum length ociuldr will read. You may need to set the proper value of this...

Posted on September 26, 2007 2:23 PM

Make some changes to the text unload utility -- ociuldr

    I made few changes to this free utility, a new option "mode=" is introduced to change the load mode, there are four different modes in sqlldr. INSERT: Load data into empty table, this is the default mode. APPEND:...

Posted on September 20, 2007 10:48 AM

Migrate data from US7ASCII database to UTF8 database

    Some old databases are created with US7ASCII character set, when the client NLS_LANG setting was the same with database character set, Oracle will not do any conversion, so the client was able to store Chinese into the database....

Posted on September 19, 2007 11:33 PM

The return (exit) code of ociuldr text unload utility

    About half years ago, someone told me to add this, because he want to get more control of ociuldr utility in his shell script. I was afraid of change any code at that time, so just left him...

Posted on September 16, 2007 6:48 PM

Unload LOBs to OS files or upload OS files to LOBs in Oracle

    Oracle CLOB and BLOB data types can be used to store long text or large images, provide better performance compare to the LONG and LONG RAW data types for row accessing. However it's not easy to manipulate them...

Posted on September 12, 2007 8:32 PM

Generate SQL Loader control file when unloading with ociuldr

    Oracle's SQL Loader (sqlldr) can be used to load rows in text file into database tables. But sqlldr need a control file to specify how to interpret the text file format, including the column (field) separator, the record...

Posted on September 12, 2007 2:21 PM

High performance for Oracle text unload or export with ociuldr

    ociuldr (Source) is a free utility used to unload Oracle rows to text file, which can be used to prepare data for data warehouse, or do the data migration from Oracle to other databases, or moving data between...

Posted on September 11, 2007 7:32 PM

How to unload or export rows as text file, excel CSV file, or excel xls file?

    When export oracle data to different database platform, text file is always a good choice and may be the only choice, if they cannot connect directly. And some time I was required to provide some rows in excel...

Posted on September 7, 2007 9:27 PM