DBA Tools

Windows GUI version of SQLULDR2 and DataCopy released.

    SQLULDR2 is a DBA utility to extract Oracle table's data to flat text file, it's based on OCI with excellent performance. Since most of uses like GUI interface, so I released a GUI version of SQLULDR2, let's call...

Posted on May 13, 2010 9:50 AM

SQLULDR2 : Native Parallel Support! Parallel Inside!

    Supposed that we want to unload a huge table (100gb+) to text file, how to do it quickly? The answer is parallel unloading. I will suggest you perform a manual parallel by split the big table into multiple...

Posted on April 30, 2010 11:43 AM

SQLULDR2 Windows Developer SDK Released.

    SQLULDR2 is a fast and flexible Oracle text unload utility, but it did not have a good GUI interface, that's because I am not good at writing Microsoft MFC program to create GUI interface. But many and many...

Posted on April 19, 2010 11:55 PM

Parallel execution of SQLULDR2 or DataCopy for huge tables

    If we want to process huge tables (few hunderds of gigabytes), it will take long time for a single SQLULDR2 or DataCopy process, single process can makde single CPU exhausted. To speedup the process, we need maually partitioned...

Posted on April 15, 2010 4:06 PM

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