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

DataCopy : Native Parallel Support Now ! Parallel Inside !

    We can write a Perl or shell script to start multiple datacopy process with TabSplit utility, now you don't need to write such a Perl or shell script, I have combined the code of TabSplit and DataCopy, we...

Posted on April 17, 2010 12:21 AM

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

Data Migration between different Oracle character set

    Supposed that we have few handerds of data stored in US7ASCII database, and we need to switch the system to an UTF8 database, how could we get the system switched in just few minutes without long period outage...

Posted on April 14, 2010 12:35 PM