Use this page to specify the database objects and schemas that you wish to compare. You can do the following:
Select the schema and non-schema object types to be compared.
When selecting:
Select object types and schemas to include, if you select the Table and Index object types, and the SYS and SYSTEM schemas, the Table and Index object types in these two schemas will be compared.
Select object types to include and schemas to exclude, if you select the Table and Index object type and the SYS and SYSTEM schema, the Table and Index object types in all schemas other than SYS and SYSTEM will be compared.
Select individual objects from any schema, you can choose individual objects from different schemas as shown in the following example:
| Schema | Name | Type |
|---|---|---|
| SYSMAN | AQ$_QUEUES | TABLE |
| SYS | ACCESS$ | INDEX |
Note: You can select individual objects only for schema objects. For non-schema objects, all objects of the selected type(s) are compared.
You can provide one or more prefix strings for schema object names. Only schema objects having names that start with one of the strings will be compared. Separate multiple prefix strings with commas. If you do not specify prefix strings, all schema objects are compared.
By default, objects in a schema in the left source are matched against corresponding objects from the same schema in the right source. You can override these default mappings and compare objects from different schemas by using the Mapped Schemas option. While mapping objects, you need to follow the rules given below.
When selecting non-schema objects, if you select Grants for Users and Roles, you must also select the Users and/or Roles object type.
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.