DBA Tools

DataCopy : Oracle data migration utility, faster than exp/imp

    We always use Oracle exp and imp utilities to move data from one oracle database to another, but the Oracle imp utility is really slow, because it does not support direct path load, and we must prepare lot's...

Posted on March 17, 2010 5:45 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

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

Implement materialized view log on MySQL for asyncdata

    Of cause, MySQL does not have materialized view log now as Oracle has. But we can implement the same feature with a log table and a trigger, since MySQL version 5 does support the trigger. In MySQL we...

Posted on September 11, 2007 5:30 PM

Using trigger for asyncdata log table in Oracle database

    Oracle materialized view log is good for capture the DML change, however it's not flexible, for example, the table must have a physical primary key defined for asyncdata, and you have no wait to skip the change capture...

Posted on September 11, 2007 12:15 PM

Tuning the performance of data replication with asyncdata

    Performance is critical for OLTP system, asyncdata should have good performance for the data replication, else it may not be able to catch up with the source table. Following is the key points to get the best performance....

Posted on September 10, 2007 10:53 PM

Migrate data between different databases with asyncdata script

    Migrate data may be a regular job for a DBA, sometime from this Oracle server to another Oracle server, and sometime migrate from Oracle to MySQL or other database, or other database to Oracle. With good utility it...

Posted on September 10, 2007 8:55 PM