Create Dictionary Synchronization : Rules Page

Use this page to specify rules for synchronization.

Following are the options defined on this page:

Element Description
Ignore Physical Attributes Select this option to ignore the values of storage attributes when synchronizing objects such as tables and indexes that occupy database storage.
Ignore Tablespace Select this option to ignore the tablespace(s) in which objects are stored when determining the objects to synchronize and when generating the script.
Constraints: Match by Name, Match by Definition Select this option to control how table constraints are synchronized.
Ignore High Values Select this option to ignore differences in high values of range partitions, that is, partitions differing only in high value will compare as same and will not be synchronized.
Preserve Data in Destination Select this option if you want the existing data in the destination database to be retained.
Copy Data From Source Select this option if you want the data in the destination database to be replaced by the data in the source database, even if they are identical.This option cannot be used when connecting to a source database with SYS user credentials.
Logical SQL Compare Select this option to ignore whitespace, case, and unnecessary quotes in SQL text contained in views, triggers, procedures, functions, packages, package bodies, and check constraints.
Ignore Table Column Positions Select this option to ignore differences in the position of columns within tables.
Drop Destination-Only Schema Objects Do not select this option if you want schema objects present in the destination database, but not in source, to be retained.

Related Topics

About Dictionary Synchronizations

Dictionary Synchronization Best Practices

Dictionary Synchronization Features

Enterprise Manager Information Roadmap