Ron,
Replication is not for the faint of heart and it would
behoove you to research this to see if replication is
really the right way to accomplish your goal.
How much time is needed to maintain a replication
environment is entirely dependent on how well the
environment was designed and implemented. When
properly designed, a replication environment does not
require that much additional maintenance. Of course,
this also depends on the complexity of the
environment. Obviously a hybrid environment
encompassing 15 databases is going to require more
maintenance than a two-database multi-master
environment.
There are many issues to consider, but one issue often
overlooked is change control. Replicated tables, for
example, cannot be modified with standard ALTER TABLE
commands so it becomes even more important to make
structural changes in a controlled fashion. Want to
bring a multi-master replication environment to its
knees? Just alter a key replicated table to add a not
null column... not a pretty sight.
HTH,
-- Anita
P.S. I'm sending you my paper which discusses many of
the issues you should consider before implementing
replication.
--- "Smith, Ron L." <[EMAIL PROTECTED]> wrote:
> We have a small but critical application running on
> NT. The user wants to
> implement replication. We have never done
> replication for Oracle. Can
> someone give me an idea of how much difficult it is
> to maintain a replicated
> database on NT. How much of my time will I need to
> allocate to keeping
> everything working?
>
> Ron Smith
> Database Administration
> [EMAIL PROTECTED]
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Smith, Ron L.
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
--------------------------------------------------------------------
> 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).
__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: A. Bardeen
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).
