Neal wrote:Hi Neal, If I understand you correctly, you basicly need a warehousing solution.
We have a requirement in our data warehouse where we have to replicate one schema to another in closer to real-time at a specific time of the day.
We run the incremental ETL's to Schema A in Database X, this process takes about 2 hours and brings 1-2GB data from scorce systems.
Schema A has total 350 GB size datafiles.
After this process completes, we want to move all the changed data into Schema B in Database X (same database, different schema) with minimal downtime to end users who runs reports in Schema B.
Since I'm not a DBA expert, I wondering the 11g streams (DBMS_STREAMS_ADM.MAINTAIN_SCHEMAS) can help to archive this.
Please share your thoughts, recommendations and any examples would be helpful.
Thanks in advance!