DBA Tools

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