Oracle Replication error

[rkayasth]

I am having some problems while trying to create replication data.I am using oracle 8i.

I am getting the following error.

***************************************************************************************
Stack Trace:------------------

ORA-06550:line 2, Column 4:
PLS-00201:identifier 'DBMS_REPCAT-ADMIN.
GRANT_ADMIN_ANY_SCHEMA' must be declared
ORA-06550 : line 2, column 4;
PL/SQL : Statement ignored

*****************************************************************************************

Can anybody pl. help me out with this, it is quite urgent.

[akhadar]

Check the privileges on the Repadmin and snapshot admin.

Let us have detail steps how u have created the replication default users i.e, repadmin and snapshot admin.

regards
akhadar

[dsimpson]

Here is an example script I use to set up the repadmin account when I set up replication:

http://www.dotcomsolutionsinc.net/pr...p_prod3_1.html

Included with the grants and roles for this repadmin account you will see where I have included:

execute dbms_repcat_admin.grant_admin_any_schema ('repadmin');

You will probably just want to go thru the whole list as you see in the example just to make sure that you have everything setup correctly.

David Simpson
http://www.dotcomsolutionsinc.net