This content has been marked as final. Show 2 replies
You are correct that you can't use materialized views for this.
You should be able to use Streams, though, which would be much easier (and safer and quicker) than writing a bunch of code to manually replicate the data. GoldenGate would be another good choice though that would require additional licenses.
Thank you Justin. I remember vaguely that Oracle is going to slowly deprecate Streams (or at least put it on maintenance and not add new features), and focus on GoldenGate. I guess I'm going to have to look into the licensing aspect of these and see if that is a solution that we can use.