DBA Tools

Oracle ASM Data Recovery Test of AUL for Oracle ASM Utility.

    I create a tablespace based on an Oracle ASM disk group with two physical disks, and create a table with 499999 rows to make sure the data distributed on two disks evenly. SQL> select disk_number, name,path from v$asm_disk;...

Posted on April 20, 2011 8:57 PM

AUL for Oracle ASM, Oracle ASM Data Recovery Utility.

    I wrote a tool for Oracle ASM data recovery, for example, if we have an Oracle ASM with 10 disks in one disk group, and one of them corrupted, how to recover the data on other 9 disks?...

Posted on April 15, 2011 7:28 PM

Trigger based data replication utility from Oracle to MySQL database

    In some read focus system, we may make copies of the write database to take the heavy read activites, however how to make a read database if we plan to write on Oracle and read from MySQL database?...

Posted on April 10, 2011 12:27 PM

Migrate Oracle data to MySQL database with ora2mysql utility

    I wrote a program named (ora2mysql) when learning MySQL C API client programing, it can be used for data migration from Oracle to MySQL database, and I think it's definatelly a good utility for DBAs who need manages...

Posted on April 8, 2011 3:41 PM

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 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

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

DataSync: Data Replication (SCOTT.EMP) between Oracle databases

    I want to introduce a new utility for data replication solution based on materialized view log or user defined triggers, I named it as DataSync, suppose that we want to replicate table (SCOTT.EMP)'s data from DB1 to DB2...

Posted on March 25, 2010 3:52 PM