Home > SQL Developer Dialog Boxes ... > Diff Objects
This dialog box is displayed if you click the Diff Objects icon in the Cart window, which is explained in Using the Cart.
Open Configuration icon: Opens a previously saved XML configuration file, to use its settings as defaults for this use of the dialog box (see Save or Open Cart Tool Configuration).
Save Configuration icon: Saves the current settings in the dialog box to an XML file, which you can later open to use for Cart operations of this type (see Save or Open Cart Tool Configuration).
Destination: Destination with objects to be compared with the source objects: Cart for another currently open cart tab, or Connection for a database connection that has access to the destination objects to be compared.
DDL Generation Options: Check the options or features to be included if you later generate a script to update the objects in the destination schema to reflect differences in the source schema: comments, schema name (prefixed to schema objects), constraints, password values, constraint indexes, referential constraints. Options that are not checked are ignored or not performed during the script generation.
Schema: This option, if you also select Schema: Consolidate under DDL Comparison Options, causes object names to be prefixed with the target schema name in the generated script (for example, CREATE TABLE "HR"."SKILLS" instead of CREATE TABLE "SKILLS"). If you select Schema: Maintain under DDL Comparison Options, this Schema option is ignored and object names are prefixed with the source schema name in the generated script.
DDL Comparison Options: Check various options, including differences to be ignored, when objects in the source and destination schemas are compared.
Note: The DDL Generation Options apply to how the DDL will be generated, whereas the DDL Comparison Options apply to how the comparison is made between the two objects. |
Schema: Consolidate and Schema: Maintain enable you either to compare the source objects with objects owned by the target connection user (schema) or with any object accessible by the target connection. The resulting behavior is largely based on which option you select and which objects your connection has access to.
Consolidate: Compares the source objects with those owned by the target schema; in other words the selected objects are "consolidated" into the target schema.
If the target connection does not own an object by that name (that is, target-schema.object-type.object-name), the object will not be found and a comparison cannot be done. If the target connection does own object target-schema.object-type.object-name, source-schema.objectname will compared with target-schema.object-type.object-name.
Maintain: Maintains the schema on the source objects and applies it in the target object processing.
If the target connection does not have access to those schema objects, they will not be found and a comparison cannot be done. If the target connection does has access to those schema objects, source-schema.object-type.object-name will be compared with target-schema.object-type.object-name.
Match Constraints By: Controls whether constraints are matched for comparison by the names (Name) or definitions (Definition).
Ignore Segment Attributes: Causes differences in segment specification to be ignored.
Ignore Table Column Position: Causes differences in the positions of table columns to be ignored when objects are compared. For example, if this option is enabled (checked), two tables would not be considered different in the only difference is that Column1 and Column2 appear first and second in one table but second and first in the other table.
Ignore Storage: Causes differences in storage specification to be ignored.
Ignore High Values: Causes differences in partition high values for tables to be ignored.
Ignore Tablespace: Causes differences in the tablespace specified for the object to be ignored.
Logical Compare: Causes meaningless SQL formatting differences in definitions of objects (such packages, package bodies, procedures, and functions) to be ignored.
Ignore Partitioning: Causes differences in partitioning specifications for the object to be ignored
The results are displayed in a Diff Report window, where you can see the DDL statements to update the objects in the destination schema to reflect differences from the source schema. To create a file containing these DDL statements, click the Generate Script (SQL) icon in that window. In the Generate SQL dialog box you can specify the Save As destination or type (Single File, Separate Files, Type Files, Separate Directories, Worksheet, Clipboard), the location, and the encoding.
To display only objects with differences that have the same name in both connections, select Show Equal Objects. To display all objects that have differences or that exist one one connection but not the other, select Show New Objects.
Related Topics