DBA Tools

Get Oracle DDL Script

    A lot of DBAs are extracting DDL (table create) script with Toad and PL/SQL Developer utilities. But a lot of database are running on Linux or Unix hosts, and connections directly from desktop are not allowed, then it...

Posted on December 24, 2007 7:26 PM

Compare index structure difference between tables

    I will introduce you how to compare index structure between tables with the compare any column utility (Overview / Download). I fixed the table structure difference found in previous case, and create the following indexes for demo. CREATE...

Posted on October 23, 2007 5:44 PM

Compare column for different tables on different databases.

    I will introduce you how to compare structure for different tables in different databases (ALL type) with the compare any column utility (Overview / Download). I create the following tables in three different databases for this demo. --...

Posted on October 19, 2007 8:12 PM

Compare column for the same table on different databases.

    I will introduce you how to compare structure for the same table in different database (TABLE type) with the compare any column utility (Overview / Download). I create the "SALES" table in three different databases for this demo....

Posted on October 16, 2007 8:25 PM

Compare column for different tables on the same database.

    I will introduce you how to compare structure for different tables in the same database (HOST type) with the compare any column utility (Overview / Download). I create the three tables in SH schema for this demo. create...

Posted on October 16, 2007 5:32 PM

Compare column script for tables on different databases.

    The ocidiff utility is just a peer-to-peer compare utility, it cannot get all of our problem resolved. For some big tables, for example the sales or the bill invoice tables, we may store the data in separate tables,...

Posted on October 15, 2007 8:03 PM

How my DBDiff (ocidiff) utility works for different objects?

    ocidiff utility is one of my own version of DBDiff utilities. There are several key tasks in this utility, let's see how it works?     How to get the SQLs to create the missing tables? In this...

Posted on October 15, 2007 7:29 PM

Compare and repair table structure between two schemas

    I have been maintaining some QA environments which require all the tables' structure should be same with the core QA environments. So we are required to add column on all the environments when make any table structure changes....

Posted on September 18, 2007 6:05 PM