Since Shareplex is used for replicating changes to data and keeps the contents of target table in sync with the source table, the question sometimes arises as to whether one can use it to synchronize the structure of object on target.
Shareplex is a tool for replication of Oracle databases. It does synchronize the data between two objects but not their definition (or structure) unless you are replicating the DDL to create that object in another database. Such DDLs are referred to as "9i Supported DDL" in Shareplex and this feature is available for Oracle 9i and up. There is another tool from Quest named Toad that should be able to compare two objects located in the same or different databases and be able to generate script for synchronizing their structure. The option used is named "Compare Schema's" and it generates the script that would be needed to sync the structure of one table with that of the other.
