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

How to improve the performance of Oracle exp/imp?

    A lot of people complain the speed of Oracle exp/imp utility, seems the only thing we can do is to specify large buffer size. Actually there are some other methods to improve the performance a little. For export...

Posted on November 28, 2007 9:32 PM

More robust DMP format support in AUL version 5

    I rewrote severl key functions in AUL to add the compress table support, but I found that the DMP format support is more robust in AUL 5. When I use the latest AUL 4 to unload table "SYS.IND$"...

Posted on November 8, 2007 7:38 PM

New command line option for text export utility -- BUFFER

    When tuning the performance of Oracle SQL loader (sqlldr), the read size and bind size option are very critical. When ociuldr utility generate the SQL loader control file for you, the default read size and bind size are...

Posted on October 11, 2007 9:31 PM

How to change the character set of the export dmp file?

    I saw somebody were asking how to change the character set id in the Oracle export file. I did once in 1998, we had a export file from a US7ASCII database, and wanted to import it into a...

Posted on October 10, 2007 2:40 PM

Oracle Bug : exp-00003 when export tables with LOB columns

    When you use old version of exp to export tables with LOB column from Oracle 9.2.0.5 or higher version, you will get an error "EXP-00003 : no storage definition found for segment .....", actually this is an Oracle...

Posted on September 29, 2007 12:12 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

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

How to specify query option of Oracle export utility.

    There is a "query" option in Oracle exp utility, which enables you export filtered rows of a table by providing a where clause with this option. However this option is not widely used, many people do not clearly...

Posted on September 25, 2007 11:00 AM

Is it dangerous to change the table owner in this way?

    SQL Server and Sybase provide a system procedure to do this job, while Oracle hasn't it. And now I receive a task to move few tables (totally 80gb) from one schema to another schema. I tested this using...

Posted on September 19, 2007 2:13 PM

The dump format recovery of AUL (MyDUL)

    AUL (MyDUL) can recover the data to dump file by setting the output style, the character set and the national character set. As following, 871 is the UTF8 character set id. AUL> SET OUTPUT_STYLE DMP   Current OUTPUT_STYLE is...

Posted on September 16, 2007 8:52 AM

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