replicated database

From: Mark Heiple <markh_at_xetron.com>
Date: 1996/07/10
Message-ID: <markh-1007961408230001_at_sw-mac-1.xetron.com>#1/1


I haven't received a response to this question yet, so I'll post it again:

I am trying to implement a replicated database. I created all my tables, owned by the user "developer". I then tried to create the replicated schema be executing

SYS.DBMS_REPCAT.CREATE_MASTER_REPSCHEMA('DEVELOPER'); I get the following error codes:

ORA_04068: existing state of packages has been discarded
ORA-04047: not executed, package body "SYS.DBMS_REPCAT_MAS" does not exist
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_REPCAT", line 44
ORA-06512: at line 1

What's the problem? I installed the replication package by running the \orant\rdbms72\admin\catrep.sql script while connected as user SYS. Why does it say DBMS_REPCAT_MAS is missing? Do I need to install something else? I ran grep on all the .sql files under \orant, and no file contains "DBMS_REPCAT_MAS". where is it? How do I install it?

I am running oracle 7.2 on Windows NT 3.51.

Thanks Received on Wed Jul 10 1996 - 00:00:00 CEST

Original text of this message