I am trying to do an exp from my newly setup database, I have the following error:
PLS-00201: identifier 'SYS.DBMS_REPCAT_RGT_EXP' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00083: The previous problem occurred when calling SYS.DBMS_REPCAT_RGT_EXP.schema_info_exp
. exporting cluster definitions
What should I do about EXP-00083, please help. Thanks.
We faced a simliar error before
this was because we created a table called SYS,
so look for any object called sys *you can do so by select from DBA_OBJECTS where name ='SYS'
if any object is found rename it.
or may be you ran catalog scripts as user system not user SYS, for example, while you were running the scripts that creates the replication repository, you logged as system, or as another user.