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

How to improve the performance of Oracle exp/imp?

    A lot of people complain the speed of Oracle exp/imp utility, seems the only thing we can do is to specify large buffer size. Actually there are some other methods to improve the performance a little. For export...

Posted on November 28, 2007 9:32 PM

More robust DMP format support in AUL version 5

    I rewrote severl key functions in AUL to add the compress table support, but I found that the DMP format support is more robust in AUL 5. When I use the latest AUL 4 to unload table "SYS.IND$"...

Posted on November 8, 2007 7:38 PM

Is it dangerous to change the table owner in this way?

    SQL Server and Sybase provide a system procedure to do this job, while Oracle hasn't it. And now I receive a task to move few tables (totally 80gb) from one schema to another schema. I tested this using...

Posted on September 19, 2007 2:13 PM