Export Error 2005-03-07 - By Robert Pegram
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@(protected) > 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@(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
>
__ ____ ____ ____ ____ ____ ______
Celebrate Yahoo! 's 10th Birthday!
Yahoo! Netrospective: 100 Moments of the Web
http://birthday.yahoo.com/netrospective/
--
http://www.freelists.org/webpage/oracle-l
|
|
