Re: ORACLE error 6550 encountered

Yuri,

The packages SYS.DBMS_REPCAT_RGT_EXP and SYS.DBMS_LOGREP_EXP are most likely invalid. Try and recompile the packages first. If the packages fail to recompile and you are not using advanced replication run the CATREPR.sql script to drop the packages.

If the script CATREPR.sql doesn't drop the packages you will have to remove the entries from the export table exppkgact$ manually.

eg. delete from sys.exppkgact$ where package = 'DBMS_REPCAT_RGT_EXP' and schema= 'SYS';

Please check with Oracle to make sure you are still supported before doing the above operation.

HTH Roger

"Yuri Weinstein (HotMail)" <yuriw_at_hotmail.com> wrote in message news:8Oawa.175$593.25175310_at_newssvr13.news.prodigy.com...
> No, they both are Release 9.2.0.1.0
>
> "Telemachus" <telemachus_at_ulysseswillreturn.net> wrote in message
> news:9V9wa.13151$pK2.18180_at_news.indigo.ie...
> > Do devdb and your client differ in version ?
> >
> >
> > "Yuri Weinstein (HotMail)" <yuriw_at_hotmail.com> wrote in message
> > news:ao9wa.170$_P2.23915710_at_newssvr13.news.prodigy.com...
> > > I ma trying to export my user like this:
> > > exp magnetic/uklever_at_devdb file=magnetic.dmp
> > >
> > >
> > > and getting errors:
> > >
> > > Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 -
Production
> > > With the Partitioning, OLAP and Oracle Data Mining options
> > > JServer Release 9.2.0.1.0 - Production
> > > Export done in US7ASCII character set and AL16UTF16 NCHAR character
set
> > > server uses WE8ISO8859P1 character set (possible charset conversion)
> > > . exporting pre-schema procedural objects and actions
> > > EXP-00008: ORACLE error 6550 encountered
> > > ORA-06550: line 1, column 13:
> > > 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
> > > EXP-00008: ORACLE error 6550 encountered
> > > ORA-06550: line 1, column 13:
> > > PLS-00201: identifier 'SYS.DBMS_LOGREP_EXP' must be declared
> > > ORA-06550: line 1, column 7:
> > > PL/SQL: Statement ignored
> > > EXP-00083: The previous problem occurred when calling
> > > SYS.DBMS_LOGREP_EXP.schema_info_exp
> > > . exporting foreign function library names for user MAGNETIC
> > > . exporting object type definitions for user MAGNETIC
> > >
> > > What is it and how can I get rrid o fthem?
> > >
> > > Thanks
> > >
> > > YuriW
> > >
> > >
> > >
> >
> >
>
>
Received on Thu May 15 2003 - 05:14:57 CDT