DDL for some tables were not replicated to target.
There may be views with the same name of the table in another schema and\or their may be public synonym on that view.
The view may have been created before you added new column.
For example:
Before Add new column
=> Schm1.XXX table has 5 columns on source
=> Schm1.XXX table has 5 columns on target
=> Create view on target Schm2.XXX as select * from Schm1.XXX
=> Create public synonym on Schm2.XXX
=> When use describe XXX on target without specify schema name, the Oracle will show 5 columns result
After add new column
=> Schm1.XXX table has 6 columns on source
=> Schm1.XXX table has 6 columns on target
=> The view was not re-created on target so view Schm2.XXX is selecting only 5 columns on target table
=> Nothing change with public synonym
When using describe XXX on target without specifying schema name, the Oracle will show only 5 columns result because it accesses the table through view Schm2.XXX.
You may expect to see 6 columns but can see only 5. This doesn't mean Shareplex is missing the DDL and was not replicating properly.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center