Set up readonly database for reporting purpose
760028Mar 14 2010 — edited Mar 14 2010Hello,
I want to setup a complete read-only database which will be a copy of our production database for the reporting purpose.
The updates on the production db should be immediately reflected in the read-only db.
What method I should use for configuring this read-only db? Our production db is oracle 10g.
If I use read-only snapshot replication, the updates from the production db will not reflect here until we make the refresh. Is there any other method? Can I use dataguard?