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.