The Oracle (tm) Users' Co-Operative FAQ

Can advanced replication be managed without the overhead of using Enterprise Manager ?


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.*)

Can advanced replication be managed without the overhead of using Enterprise Manager? 
I've heard that it can be administrated from the command line, as long as the databases in question have the advanced replication option built.

Back to index of questions


Advanced replication can be fully setup and managed without Enterprise Manager. However for this purpose it is necessary to write or to find plenty of scripts and to study the Replication Management API.

Generic Oracle's documentation includes a good guide to create Advanced Replication environment. An extremely useful script, printing the replication transactions and working much faster than OEM, can be found on metalink.oracle.com  (Note:131279.1)

In addition, some people recommend the book named 'Oracle Built-In Packages' (Feurestein, Dye & Beresniewicz, O'Reilly Press, 1998) containing lots of explanation about using the 'command line' (actually calls to packages) for managing Replication.


Further reading: Oracle8i Replication Management API Reference


Back to top

Back to index of questions