RE: Export error

From: Mercadante, Thomas F <thomas.mercadante_at_labor.state.ny.us>
Date: Mon, 7 Mar 2005 08:00:21 -0500
Message-ID: <C9995D8C5E0DDA4A8FF9D68EE666CE0704AC02F7@exchsen0a1ma>

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_at_TFMC.co.za] Sent: Friday, March 04, 2005 6:33 AM
To: oracle-l_at_freelists.org
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

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l

Received on Mon Mar 07 2005 - 08:03:44 CST