Chat now with support
Chat with Support

Toad for Oracle 12.12 - Getting Started Guide

Table of Contents Welcome to Toad Toad Resources Required Privileges Create and Manage Database Connections Editor Basics Schema Browser Basics Data Grid Basics Work with Data Work with Database Objects Work with Code
Write Statements and Scripts Work with the Query Builder Execute Statements and Scripts Save Statements (SQL Recall) Work with PL/SQL Objects Debug Analyze Code Optimize SQL
Customize your Toad Environment Use Other Quest Software Products with Toad

Compare Databases

You can compare database-level objects such as tablespaces, roles, users, and so on between databases or Database Snapshot files.

This feature is only available with the DB Admin Module, which is included in several Toad Editions or can be purchased separately.

To compare databases

  1. Select Database | Compare | Databases.
  2. Complete the fields as necessary. 
    Tab Field Description

    Reference Source

    Select a live database or database definition file to use as the basis for comparison. If you execute the sync script, the target database is updated to match the reference source.

    Tip: If you select Create Database Snapshot File, you can use variables in the filename. By default, Toad includes the %DATEFILE% and %TIMEFILE% variables, which inserts the current date and time into the filename when it creates the definition file.


    Targets and Output

    Click in the Live Databases or Snapshot Files field to add a target database for comparison. You can repeat this step to compare multiple target databases to the source.

    Tip: Right-click a target to edit it, delete it, or switch it with the reference source.



    Database Object Types

    Select the object types you want to compare. Reducing the object types reduces the amount of time it takes to complete the comparison.

    Tip: Right-click to select or clear all fields, and to save or recall your settings.


    Safe Drop on users, tablespaces, and profiles

    Select to only drop a user or tablespace if it does not own any objects, or a profile if no users are assigned to it.

    Object Set



    Specify Object Set

    Select to determine specific object sets to compare. This lets you limit your comparison even more than the Options tab. Note: If Compare Databases was opened as the result of the Compare with another object command targeting a selection of Users, the selected Users are shown here.

    Click to add an object set. If you already have objects loaded, a confirmation dialog ask you if you want to clear the grid before loading the new objects. Click Yes to start over, or No to append the new objects into the grid.

  3. Click to execute, or save or schedule the selections as a Toad action. See Automation Designer Overview in the online help for more information.

    Tip: You can execute actions from the command line. See Execute Actions from the Command Line in the online help for more information.

  4. Review the differences on the Results tab. Review the following for additional information:


    Action to take

    Show the sync script for selected objects.

    Select the objects and click .

    View the differences for one object

    Select the objects and click .

    View the differences for another target Select the target in the Target Database field (only applicable if you selected more than one target for comparison).
  5. To sync the databases, select the Sync Script tab and click to execute immediately from the Editor or to schedule its execution.

    Caution: Review this script thoroughly before executing it to prevent unintentional data loss.


Rebuild Objects

Toad enables you to view, add, modify, and get information about database objects. You can work with these objects quickly and without having to use SQL commands.


About Rebuilding Objects

Use the Rebuild Multiple Objects window to identify objects that need to be rebuilt, and then set criteria to rebuild them simultaneously.

Rebuild Multiple Objects

You can also rebuild one index or table at a time from the Schema Browser, with a simpler interface.


Rebuild a Table

Use this function to rebuild a table, including dropping and renaming columns.


  • You can simultaneously rebuild multiple tables with the Rebuild Multiple Objects feature.
  • You must own the schema in order to rebuild a table from it.

To rebuild a table

  1. Click image\Toad0015.gif on the Standard toolbar to open the Schema Browser.
  2. Right-click the table in the left-hand side and select Rebuild Table.

    Tip: You can also select Database | Optimize | Rebuild Table.

  3. Select settings as necessary on the Options tab.
  4. Select parameters as necessary on the Table Storage and Index Options tabs.

    Note: The parameters in this window are defined by Oracle. See Oracle's documentation for more information. You can also find detailed information about parameters in Knowledge Xpert. Knowledge Xpert is an extensive Oracle technical resource which you can search in Jump search. Jump Search

  5. To add, edit, or drop a column, use the toolbar buttons on the Columns tab.
  6. To view the ALTER statement, select the Script tab.
  7. To execute the rebuild, click on the Rebuild Table toolbar. Note: You can also use the toolbar buttons to schedule, copy, regenerate, and save the script.


Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating