I need to keep two whole databases constantly synchronized.
- Data (of course)
- DDL Changes (also changes to stored procedures and pl/sql packages)
All changes need to be propagated back and forth. E.g. changes to one database must be visible in the other database as soon as possible.
The databases are geographically separated by a few thousand miles and the connection between them is quite slow and cannot be made faster.
The size of the databases is maybe 100GB.
Can this be done with Oracle Streams? How would you do it?