Re: Basic replication question

From: <babu.nagarajan_at_Cummins.com>
Date: Mon, 21 Feb 2005 10:50:31 -0500
Message-id: <OF6A60D85F.2A00DE97-ON05256FAF.0056EF67-05256FAF.00570613@cidc.cummins.com>

I think you would just need to create a procedure on your snapshot sites that call "dbms_mview.refresh" and then call that procedure you created from where ever u want..

Thanks

Babu

                                                                                                                                        
                      Mark Bole                                                                                                         
                      <makbo_at_pacbell.net        To:                                                                                     
                      >                         cc:       Oracle-L_at_freelists.org                                                        
                      Sent by:                  Subject:  Re: Basic replication question                                                
                      oracle-l-bounce_at_fr                                                                                                
                      eelists.org                                                                                                       
                                                                                                                                        
                                                                                                                                        
                      02/21/2005 09:56                                                                                                  
                      AM                                                                                                                
                      Please respond to                                                                                                 
                      makbo

John Dunn wrote:

> I am experimenting with replication for teh first time(Oracle 9i) and
> wondering whether basic replication will provide what I need.
>
> I will have 1 master site and 2 sites where read-only snapshots will need
to
> be refreshed.
>
> I would like to have control over when the snapshots at the 2 sites are
> updated. I would like to be able to initiate the refresh of the 2
snapshot
> sites from the master site.
>
> Since the refresh groups exist at the snapshot sites, Is what I want
> possible?
>
> John
>

The use of scheduled (automatic) refreshes (and even refresh groups) is optional, so yes you should be able to do what you want. Simply don't schedule any refreshes at the snapshot sites, and then execute DBMS_REFRESH.REFRESH from wherever you want on your network, whenever you want.

--
Mark Bole
http://www.bincomputing.com



--
http://www.freelists.org/webpage/oracle-l

______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________





--
http://www.freelists.org/webpage/oracle-l

Received on Mon Feb 21 2005 - 10:53:44 CST