A dictionary comparison identifies differences in database object definitions between two databases, a database and a baseline, or two schemas within a single database/baseline.
Comparisons are generated using comparison specifications. A comparison specification is defined by its name, left and right sources, scope specification, and owner. The scope specification describes the names and types of database object definitions to be included in the comparison and the schemas which contain these object definitions.
Note: You cannot change the name, left and right sources, and the owner of a comparison once it has been created.
Comparisons identify differences in any attribute value between objects of any type. Use comparison specifications to create multiple versions of a comparison. Each version has a unique version number and a comparison date. Use these versions to associate comparisons of database/schemas made over time.
Examples:
Comparison specifications show differences between definitions in the original baseline for your application and those in your current database. After creating a new comparison version, it identifies the differences between the original definitions at the start of the development cycle, and those same definitions at the current time.
Use another comparison specification to compare definitions from your most recent baseline with those in your previous baseline. With each newly created version of this comparison using the comparison specification, that comparison version identifies the differences in the definitions since the previous baseline.
Related Topics
Comparing Database Object Definitions
Enterprise Manager Information Roadmap
Copyright © 1996, 2010, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
Other names may be trademarks of their respective owners.