Michael By distributed, I assume you mean "replication"? From what I can tell, basic replication is included with Standard Edition and advanced replication is included with Enterprise Edition. I think you run a script, something like "catrep.sql" in rdbms/admin, so you should be able to get the pieces installed. Replicating between different Oracle versions could be challenging, but doable. Others on the list can probably offer specific advice on pitfalls. We haven't implemented replication here, just studied. From what I can tell, planning for replication is everything. I have only been able to find 2 books on it. The prize is Marie Buretta's Database Replication. http://www.amazon.com/exec/obidos/ASIN/0471157546/qid%3D1041023613/sr%3D11-1 /ref%3Dsr%5F11%5F1/102-1511927-6720101 It really tells you everything you need as an organization to prepare for replication. Replication takes a lot of administration so it should be a gold mine since you are consulting. The other book is Oracle Distributed Systems by Charles Dye http://www.amazon.com/exec/obidos/ASIN/0471157546/qid%3D1041023613/sr%3D11-1 /ref%3Dsr%5F11%5F1/102-1511927-6720101
Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -----Original Message----- Sent: Friday, December 27, 2002 2:39 PM To: Multiple recipients of list ORACLE-L I've got a client that needs "distributed option" installed on several databases, versions 7.3.4, 8.0.5, and 8.1.7... Problem may be I'm not sure we'll have all the CD's as vendors of applications did most of the installs and we think we'll find that they took the CD's with them. After all, if it's up and running and vendor supported(or was), why would the client need the CD? Anyhow, is it just a "free" option that will need to be selected with the Oracle installer, or is it an "add on" that one is supposed to contact Oracle on? Or perhaps it just involves running one of those all but undocumented packages. There are many ways to work around this if we have to, but would like to know what all is involved if we can get the distributed option installed on all of their databases. It's on my Personal Oracle, but seems to be part of a general set of things that get installed. Kline's Consulting Michael Alan Kline, Sr., Owner 13308 Thornridge Court; Midlothian, VA 23112, USA. Work: 804-744-1545 Cell: 804-314-6262 Pager: 877-705-1155 ICQ: 1009605, 975313 [EMAIL PROTECTED]; [EMAIL PROTECTED]; -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Kline INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
