Re: Oracle 7.3

David A. Cook wrote:
>
> I would like to ask a few questions about 7.3 and symmetrical
> replication.
> I work for a large, 1,000+ chain of restaurants and I have a few
> technical questions.
> 1) Does anyone have experience with a large distributed DBMS using
> Oracle 7.3? We
> would like to keep the master databases at the stores and replicate
> with Corporate periodically.
>
> 2) Any ideas on a price range for this type of setup?
>
> 3)We have legacy financial systems and would need to interface
> information from this database to the 390.
> Would I do this with PL/SQL, or could we just write COBOL programs
> with embedded SQL to get at the information
> we need from this database?
>
> I apologize, but I am somewhat less technical, and I am trying to
> justify a move to Oracle.
>
> Thanks in advance, cstp04_at_daphnis.cs.depaul.edu
> --
> David A. Cook
A1) If you're maintaining a single site master and read-only copies, use native Oracle snapshots, which does not require the Replication Option. If the copies can be changed and the changes are to be reflected back to the master, you'll need the Replication Option.

A2) I don't quote prices.

A3) Either would work, but you'd need an Oracle-compatible gateway between the platforms, like Oracle's Transparent Gateway family of products.

Call Oracle Client Relations at 415-506-1500 for more info.

-- 
Rich Woods
Technical Field Support Specialist, Oracle Corporation, USA
The above statements and opinions are my own and do not
necessarily represent those of Oracle Corporation.