Re: Snapshots crossing Multiple Platforms

Peter

In article <3qcauv$70s_at_kwuz.nerc-keyworth.ac.uk>, Peter Robson <e_pgr_at_va.nmh.ac.uk> writes:
> stromble_at_wnet.gov.edmonton.ab.ca (Sue Trombley) wrote:
> >
> > Has anyone successfully implemented a snapshot of an Oracle database across
> > > more than 1 platform ?

.
.
> Yes, we have been doing this for a few years. Four Oracle instances,
> two on VAX/VMS, two on SUN/Unix. Using LAN and WAN (300+ miles). VAX and
> SUN at each site. Our requirement is to maintain database currency between
> all four on a 24-hour basis. No one instance a master, but any can be a
> master site, distributing to the other three (in any combination).
>
> Not exactly a snapshot, but probably what you are enquiring about. Updates
> consist of individual rows, identified by time stamping. Proven very
> reliable, so long as CBS ftp doesn't crash!
>
> Come back for more if you require...

James, a few questions. When you say snapshot are you refering to Oracle's snapshot facility?

Are these tables read-only tables? If not, how so as snapshot tables are read-only
or are you using a different method?

ta
tony

-- 
 _____       ________ / ___ |Tony Jambu, Database Consultant
  /_  _        /_ __ /      |Wizard Consulting,Aust (ACN 065934778)
 /(_)/ )(_/ \_/(///(/_)/_(  |CIS: 100250.2003_at_compuserve.com FAX: +61-3-4163559
 \_______/                  |EMAIL:TJambu_at_wizard.com.au PHONE: +61-3-4122905