I get the same error on a database I inherited. I looked into fixing it once, but determined it was not worth the risk. The error does not happen in test, and I can still use the export file to restore the application data into another database. There are plans to upgrade that instance this year, so I will take that opportunity to fix this problem (and several others). HTH, Rob Pegram Duke University --- "Mercadante, Thomas F" <thomas.mercadante@xxxxxxxxxxxxxxxxx> wrote: > Denham, > > 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@xxxxxxxxxx] > Sent: Friday, March 04, 2005 6:33 AM > To: oracle-l@xxxxxxxxxxxxx > 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: 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 > . exporting cluster definitions > ...... > ..... > .... > ...... > . exporting post-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 > . exporting user history table > . exporting default and system auditing options > . exporting statistics > Export terminated successfully with warnings. > > Many Thanks > Denham > -- > //www.freelists.org/webpage/oracle-l > -- > //www.freelists.org/webpage/oracle-l > __________________________________ Celebrate Yahoo!'s 10th Birthday! Yahoo! Netrospective: 100 Moments of the Web http://birthday.yahoo.com/netrospective/ -- //www.freelists.org/webpage/oracle-l