DBA Tools

Migrate data from Oracle to MySQL with SQLULDR2

    More and more people are moving non-important data out of Oracle to MySQL for lower Oracle license fee. For DBAs, we need to know how to migrate data from Oracle to MySQL quickly. I will introduce you how...

Posted on October 29, 2009 11:55 PM

Protect the database connection information in SQLULDR2

    Some departments need to extract rows from the production daily for busines analyze, so we decide to open the standby in read only mode for data extracting with database link. The database link can protect the database user...

Posted on June 11, 2009 8:58 PM

SQLULDR2 Bug: ORA-24345 error possible

    It's possible to get ORA-24345 error when you unload data with SQLULDR2, this error is due to no enough memory buffer allocated for column binding, the column data returned exceed the maximum length declared. After a full code...

Posted on June 5, 2009 8:08 AM

How to change SQLULDR2 session level's parameters?

    Somebody need to change the date type format (default, "yyyy-mm-dd hh24:mi:ss"), and change the numeric characters. For Oracle, you can run some "alter session set ..." commands to make the changes, so I add a new command line...

Posted on June 3, 2009 4:20 PM

SQLULDR2, upgrade of ociuldr, free of charge now.

    Lot's of DBAs may know the ociuldr utility, to extract rows from Oracle to text file. Now I rewrite ociuldr with OCI 8, and rename it to SQLULDR2 with better performance (almost double) and some good new features,...

Posted on May 5, 2009 7:04 PM

SQLULDR2 can compress the output file in GZIP format

    Data compress can save a lot of storage for data archiving, GZIP is a good choise between the compress ratio and compress speed, many utilities support GZIP feature, such as rsync with "-z" option. I spent some days...

Posted on April 17, 2009 4:37 PM

Performance test of Oracle datapump, exp and SQLULDR2.

    I did a performance comparation of Oracle datapump, export and SQLULDR2 on a linux machine, the CPUs' frequency is 3G HZ. When running exp and SQLULDR2, the relative process take almost 100% of one CPU, so for data...

Posted on April 10, 2009 10:21 AM

License required for full SQLULDR2 (Oracle Text Unload) version.

    SQLULDR2 is not full free for extrading rows to text file from Oracle database. The ociuldr is still free, but SQLULDR2 is stronger than ociuldr, both in performance and features. If you want to extract huge table (tens...

Posted on April 2, 2009 6:39 PM

SQLULDR2, how to unload data to screen (STDOUT)?

    What's STDOUT, it's the standard output device for a computer, usually it meas the screen. Somebody suggested me to add this feature to ociuldr few months ago, but I did not understand the requirements at that time. Now...

Posted on April 1, 2009 9:46 PM

Specify table name for SQLULDR2 (SQL*Unloader) text unloading

    SQLULDR2 can run as fast as Oracle exp utility with default command line options. If you increase the buffer to 1 megabyte for exp, it's still 15% faster than SQLULDR2. And may be much faster in direct mode...

Posted on April 1, 2009 4:10 PM