Re: How to keep a 'shadow' database
From: David Thornewill von Essen <ttg242_at_newton.sps.mot.com>
Date: Thu, 24 Jun 1993 04:50:59 GMT
Message-ID: <1993Jun24.045059.26159_at_newsgate.sps.mot.com>
Date: Thu, 24 Jun 1993 04:50:59 GMT
Message-ID: <1993Jun24.045059.26159_at_newsgate.sps.mot.com>
In article 20aibmINNhfm_at_xs4all.hacktic.nl, gijs_at_hacktic.nl (Gijs Bok) writes:
>Hi,
>I will be participating in a project that needs a database being
>replicated on a second disk, preferably updated with every update
>on the normal disk. We are using Oracle 7, Vax VMS, and Pro*Ada.
>
>Is this possible with Oracle?
>
>Is it elegantly implemented or does it require ugly hacks?
>
Elegance is a dangerous word, having followed a 2 month thread on C.S-E.
Anyway, depending on your requirements you could use either SNAPSHOTS or
create your own triggers to do the job. Both described in the manual.
--- Regards, David TvE +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+- David Thornewill von Essen Sr. Systems Analyst Motorola ASIC Division I don't speak for Mot. Chandler, AZ-85224 fax: (602) 814-4451 email: ttg242_at_email.sps.mot.com tel: (602) 814-4395 +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-Received on Thu Jun 24 1993 - 06:50:59 CEST