We have a high transaction Oracle Database (running 11g Enterprise) that supports an automated sorting facility. We are trying to figure out the best way to replicate the data from that database to a separate database (running Oracle 11g Standard) for reporting purposes. One option that was proposed was using the Oracle Streams feature (tutorial below)...
Tutorial: Configuring Two-Database Replication with a Downstream Capture Process
This sounds promising, but I am no Oracle expert by any means... does anyone know if this setup can be used if the production database is running Enterprise Edition, and the reporting database is running Standard Edition?