Re: Oracle Replication (Search for DBMS_REPCAT_UTL)

From: Isa <Isa_at_address.com>
Date: Mon, 05 Oct 1998 16:56:25 GMT
Message-ID: <3620f886.13405886@news.cbn.net.id>

You may haven't execute

- dbms_repcat_auth.grant_surrogate_repcat(replication_admin)
- dbms_repcat_auth.grant_admin_any_repgroup(replication_admin)
- grant execute on dbms_defer to replication_admin w/ grant option
- finally, check, whether that package are exist or not. If not, you

must run catrep.sql first.

On Fri, 02 Oct 1998 16:34:22 +0200, Jens Hauptmann <hauptman_at_isys-software.de> wrote:

| Hi Oracle masters!
|
| I'd like to install a multi-master replikation under Oracle 7.3.4
|
| and therefor I made the usual steps:
| CREATE PUBLIC DATABASE LINK
| DBMS_REPCAT.CREATE_MASTER_REPGROUP
| DBMS_REPCAT.CREATE_MASTER_REPOBJECT
| DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT
|
| but calling
| DBMS_REPCAT.ADD_MASTER_DATABASE
| failed. I got the error message:
| identifier 'DBMS_REPCAT_UTL.INSERT_DESTINATION_at_BLABLA.WORLD' must be
| declared
|
| ------------------------------------------------------------------------
|
| Am I missing PL/SQL package DBMS_REPCAT_UTL ?
| How can I get it?
|
| Thanks for feedback,
| Jens Hautpmann.
|
Received on Mon Oct 05 1998 - 11:56:25 CDT