Re: Oracle on multiple sites

Hi,

 Manual is not an option, I'm currently doing that with the fox pro and i'm getting sick of it.

Pete Sharman <psharman_at_us.oracle.com> wrote:

> This is a multi-part message in MIME format.
> --------------21FB23D6802DDB70D855AA7F
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> Steve
>
> This can be done in a number of ways. Which is correct for you needs more
> information before you can decide.
>
> 1. Replication is designed to handle exactly this sort of situation (see
> the earlier posts by Jonathan Lewis, Kevin Lewis and myself for more
> details).
>
> 2. Given the small data volumes, it may not be worth the time etc. to set
> up replication, but maybe you can do something manual. This could be either
> through the use of database links, or some file based system you write
> yourself.
>
> HTH.
>
> Pete
>
> Steve-a wrote:
>
> > Hi,
> > Looking for some advice on linking 2 /3 sites.
> >
> > Each site has oracle 8 installed.
> > The databases are /should be identical, but any updates must be
> > replicated to all sites,
> > None of the sites would SQL any other of the sites, since the data would
> > be held locally and synced by oracle.
> > data flow will be Quite small 20/30 records added/modified per day.
> >
> > Which setup do I need.
> >
> > steve
> >
>
> --
>
>
> Regards
>
> Pete
>
>
> --------------21FB23D6802DDB70D855AA7F
> Content-Type: text/x-vcard; charset=us-ascii;
> name="psharman.vcf"
> Content-Transfer-Encoding: 7bit
> Content-Description: Card for Pete Sharman
> Content-Disposition: attachment;
> filename="psharman.vcf"
>
> begin:vcard n:Sharman;Peter tel;fax:+1.650.633.1669
> tel;work:+1.650.607.0109 x-mozilla-html:FALSE url:http://www.oracle.com
> org:Worldwide Internal Services Education;Oracle Corporation adr:;;500
> Oracle Parkway M/S OPL-B1024;Redwood Shores;California;94065;USA
> version:2.1 email;internet:psharman_at_us.oracle.com title:Project Manager
> note;quoted-printable:SQL> select standard_disclaimer, witty_remark=0D=0A
> 2 from company_requirements;=0D=0A=0D=0A **** The statements and
> opinions expressed here are my **** =0D=0A **** own and do not necessarily
> represent those of **** =0D=0A **** Oracle Corporation.
> =20 ****=0D=0A=0D=0A"Controlling application developers is like
> herding cats." =0D=0AKevin Loney, ORACLE DBA Handbook =0D=0A=0D=0A"Oh no
> it's not! It's much harder than that!" =0D=0ABruce Pihlamae, long term
> ORACLE DBA x-mozilla-cpt:;29648 fn:Pete Sharman end:vcard
>
> --------------21FB23D6802DDB70D855AA7F--
Received on Mon Jun 14 1999 - 19:54:18 CDT