Compare has a number of options available to sync the target table that goes out of sync due to DML. The question arises as to whether compare command can be used to sync the structure of source and target tables.
General information.
The "compare table" command is only designed to sync the data in the replicating tables. It does not sync both the data and the table structure. For this, other means need to be used. One option would be Oracle Export/Import utility.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center