Scenario:
I have 2 9i database instances on a Suse Linux 7.1 server. The projected plan is to have one database as the master and the other is the replicate. The replicate will be used for reports, while only the master will be updated, then propagate updates to the replicate.

What I tried:
After some reading, I thought setting up a Materialized View Replication is the way to go. Using OEM Console, I tried using the wizards for setting up the target master site, materialized view site and replication users. After completing the wizards, I get no error messages. I look at the tabs for the master and materialized views, but the values are still zero. How do I know anything is working? All I know is that repadmin and mvadmin have been created. Where do I go from here?

Thank you.