Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

ORACLE error 6550 encountered

64 views
Skip to first unread message

Yuri Weinstein (HotMail)

unread,
May 13, 2003, 12:51:18 PM5/13/03
to
I ma trying to export my user like this:
exp magnetic/uklever@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

Telemachus

unread,
May 13, 2003, 1:26:29 PM5/13/03
to
Do devdb and your client differ in version ?


"Yuri Weinstein (HotMail)" <yu...@hotmail.com> wrote in message
news:ao9wa.170$_P2.23...@newssvr13.news.prodigy.com...

Yuri Weinstein (HotMail)

unread,
May 13, 2003, 2:27:17 PM5/13/03
to
No, they both are Release 9.2.0.1.0

"Telemachus" <telem...@ulysseswillreturn.net> wrote in message
news:9V9wa.13151$pK2....@news.indigo.ie...

Telemachus

unread,
May 14, 2003, 5:28:28 AM5/14/03
to
Are triggers in place and if so does it work when you enable the catalog
role for the user ?

"Yuri Weinstein (HotMail)" <yu...@hotmail.com> wrote in message
news:8Oawa.175$593.25...@newssvr13.news.prodigy.com...

Roger Jackson

unread,
May 15, 2003, 6:14:57 AM5/15/03
to
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)" <yu...@hotmail.com> wrote in message

news:8Oawa.175$593.25...@newssvr13.news.prodigy.com...

0 new messages