Question about Read-Only Snapshots

Hello All, 
 

I need to implement read-only snapshots across a database link - the
simplest replication.  Here's the steps I took:

 

1.  Created a materialized view log on a table in the source db I want
to snap over

2.  Created a materialized view in the target database selecting over
the db link

3.  Created the refresh job

 

It seems to work.  

 

My question is, in Step #1:  Does the materialized view log have to be
owned by the same schema that owns the base table?  

 

If I can, I'd like to separate the mv logs so the users who browse the
database aren't confused.  In TOAD, snapshot logs show up under the
TABLES tab.  Sounds silly I know but the less complex this is for the
developers, the better off we will be.  

 

So if I can create the materialized view log under another schema, which
schema do I select from across the database link in Step #2?  The MV
owner or the table owner?  

 

I tried to read the replication manual but it starts with a messy
multimaster and MV implementation.. I don't need that, it was so
confusing.  I want to understand the basics, know how they work, and
start with a simple implementation.  

 

Thanks in advance for any suggestions.  Have a great weekend, everyone

 

Lisa Koivu

Senior Monkey

Orlando, FL, USA

 

 



"The sender believes that this E-Mail and any attachments were free of any 
virus, worm, Trojan horse, and/or malicious code when sent. This message and 
its attachments could have been infected during transmission.  By reading the 
message and opening any attachments, the recipient accepts full responsibility 
for taking proactive and remedial action about viruses and other defects. The 
sender's business entity is not liable for any loss or damage arising in any 
way from this message or its attachments."

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: