Create Dictionary Synchronization : Objects Page

Use this page to specify the database objects and schemas that you wish to synchronize. You can do the following:

Select the schema and non-schema object types to be synchronized. Non-schema objects can only be included if the source database is of version 9.2 or higher.

Usage Tips

When selecting:

Select object types and schemas to include, if you select the Table and Index object types, and the SCOTT and HR schemas, the Table and Index object types in these two schemas will be synchronized.
Select object types to include and schemas to exclude, if you select the Table and Index object type and the SCOTT and HR schemas, the Table and Index object types in all schemas other than SCOTT and HR will be synchronized.

For example, consider a source with schemas A and B, and a destination with schemas B and C. If you only exclude schema B, then schemas A and C will come under the scope of the synchronization. The synchronization will attempt to create schema A in the destination database since it does not exist in the destination. But the objects of schema C will be dropped only if you choose the rule "Drop Destination-Only Schema Objects" in the Rules page of the wizard.

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 synchronized. Separate multiple prefix strings with commas. If you do not specify prefix strings, all schema objects are synchronized.

By default, objects in a schema in the source are matched against corresponding objects from the same schema in the destination. You can override these default mappings and synchronize objects from different schemas by using the Mapped Schemas option. While mapping objects, you need to follow the rules given below.

If you specify a destination schema that does not exist, it will be created.
You can map any schema only once.
Schema map rows cannot be empty.

Users, grants, and roles cannot be synchronized directly, but if the schemas included in the scope specification need them to be syncrhonized, they will automatically be included. For more information about selecting objects for synchronization, see Dictionary Synchronization Features.

The following schema object types can only be selected in a group:

Table
Index
Cluster
Materialized View
Materialized View Log

You can either select all of the above types or none of them.

The following schemas or roles cannot be synchronized using Dictionary Synchronization:

SYS
SYSTEM
PUBLIC

Dictionary Synchronization does not support synchronizing the following schemas. Synch creation wizard will issue a warning if any of these schemas are included within the synchronization scope:

ANONYMOUS, APEX_PUBLIC_USER, CTXSYS, DBSNMP, DIP, EXFSYS, FLOWS_030000, FLOWS_FILES, MDDATA, MDSYS, MGMT_VIEW, OLAPSYS, ORACLE_OCM, ORDPLUGINS, ORDSYS, OUTLN, OWBSYS, SI_INFORMTN_SCHEMA, SPATIAL_CSW_ADMIN_USR, SPATIAL_WFS_ADMIN_USR, SYSMAN, TSMSYS, WKPROXY, WKSYS, WK_TEST, WMSYS, XDB, XS$NULL

Note: For this release, dictionary synchronization does not support synchronizing database initialization parameters and rollback segments.