As of oracle 9i catrepr.sql is not supported any more, open a TAR with oracle and they will help you clean replication objects mess.

________________________________

From: Paul Murgatroyd [mailto:oracledba-ezmlmshield-x50371481.[Email address protected]
Sent: Thu 4/7/2005 9:41 AM
To: LazyDBA Discussion
Subject: Re[2]: Export 9.2.0.6 SYS.DBMS_REPCAT_RGT_EXP



Did you run catpatch.sql when you did the upgrade from your previous version?

*********** ORIGINAL MESSAGE ***********

On 7/04/2005 at 5:14 AM Hefington Monica wrote:

I have ran these several times.

________________________________

From: Singh Gurvinder [mailto:oracledba-ezmlmshield-x36421033.[Email
address protected]
Sent: Thu 4/7/2005 1:16 AM
To: LazyDBA Discussion
Subject: RE: Export 9.2.0.6 SYS.DBMS_REPCAT_RGT_EXP



there are probably invalid replication related packages in the database.
run these scripts as sysdba

catrepr.sql (removes replication related objects)

catrep.sql (creates replication related objects)

utlrp.sql (recompile invalid PL/SQL modules)

rerun the import.



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html






--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html





--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html




Oracle LazyDBA home page