Look under the SYS schema for a table called EXPACT$. Look for the
SYS.DBMS_REPCAT_RGT_EXP entry in this table.
When Oracle export runs, it uses this table to determine what additional
tables need to be exported - even if you didn 't ask them to be exported. I
have deleted entries in this table in the past when I got the same error
that you got, and the error went away. The example I use is the ORDSYS and
MDSYS stuff. I dropped these schema 's in the past and export complained
about the tables not being there. I removed the entries and all was fine.
*Caution*. If you do this and your database dies, it 's not my fault!!!
Good Luck!
Tom
-- --Original Message-- --
From: Denham Eva [mailto:EVAD@(protected)]
Sent: Friday, March 04, 2005 6:33 AM
To: oracle-l@(protected)
Subject: Export error
Hello Listers
Does someone please have some advice. An export error has appeared since
a colleage created a database with replication and as we don 't have a
license I removed this product using the catrepr.sql script.
However I now have the following error and would like to know how to get
rid of it.
.......
. exporting pre-schema procedural objects and actions
EXP-00008: ORACLE error 6550 encountered
ORA-06550 (See ORA-06550.ora-code.com): line 1, column 13:
PLS-00201: identifier 'SYS.DBMS_REPCAT_RGT_EXP ' must be declared
ORA-06550 (See ORA-06550.ora-code.com): 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
......
.....
....
......
. exporting post-schema procedural objects and actions
EXP-00008: ORACLE error 6550 encountered
ORA-06550 (See ORA-06550.ora-code.com): line 1, column 13:
PLS-00201: identifier 'SYS.DBMS_REPCAT_RGT_EXP ' must be declared
ORA-06550 (See ORA-06550.ora-code.com): 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 user history table
. exporting default and system auditing options
. exporting statistics
Export terminated successfully with warnings.
Many Thanks
Denham
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
