The Oracle (tm) Users' Co-Operative FAQ

What's the problem with using replication on 24x7 sites?


Author's name: Vadim Grepan

Author's Email: vadim@elibron.com, kezal@mail.ru 

Date written: 04-Sep-2001

Oracle version(s): 8i (8.1.*)

What's the problem with using replication on 24x7 sites?

Back to index of questions


It's ok if the scheme is fully verified and needn't to change, otherwise you'll face real PITA. To alter the table/trigger/package, it will be necessary to switch all master replication sites into quiesced mode, at which the databases can work only for reading (update/insert/delete operations are forbidden). It concerns only objects from master groups.


Further reading: Oracle8i Replication


Back to top

Back to index of questions