Home » RDBMS Server » Server Utilities » Export oracle error messages
Export oracle error messages [message #63777] Fri, 05 November 2004 18:13 Go to next message
Maria
Messages: 57
Registered: August 1999
Member
Hello

I have an oracle instance running on solaris 5.8 oracle 10.1.0.3 and when I export the database I get a bunch of error messages which I dont know why?

. exporting private type synonyms
. exporting object type definitions
. exporting system procedural objects and actions
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 13:
PLS-00201: identifier 'EXFSYS.DBMS_EXPFIL_DEPASEXP' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00083: The previous problem occurred when calling EXFSYS.DBMS_EXPFIL_DEPASEX
P.system_info_exp
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 13:
PLS-00201: identifier 'EXFSYS.DBMS_EXPFIL_DEPASEXP' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00083: The previous problem occurred when calling EXFSYS.DBMS_EXPFIL_DEPASEX
P.system_info_exp
. exporting pre-schema procedural objects and actions
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 13:
PLS-00201: identifier 'EXFSYS.DBMS_EXPFIL_DEPASEXP' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
--More--(3%)
Re: Export oracle error messages [message #63785 is a reply to message #63777] Sun, 07 November 2004 10:24 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Hi,

Run catalog.sql, catproc.sql and catexp.sql as SYS on
your database, and re-try the export. These scripts
are in your $ORACLE_HOME/rdbms/admin/ directory. You
might want to spool the output to a file to ensure it
goes through successfully.

Best regards.

Frank
Re: Export oracle error messages [message #207687 is a reply to message #63777] Wed, 06 December 2006 11:06 Go to previous messageGo to next message
sukesh_DBA
Messages: 2
Registered: December 2006
Location: Calcutta , India
Junior Member

For this error , we need to install the EXFSYS schema. This schema is not part of the typical installation of the database.The procedure tfor installing the EXFSYS schema is:

1. Login as SYSDBA
2. @$ORACLE_HOME/rdbms/admin/catexf.sql

This will solve the problem.

Warm Regards,
Sukesh Roy
Oracle DBA

[Updated on: Wed, 06 December 2006 11:08]

Report message to a moderator

Re: Export oracle error messages [message #207706 is a reply to message #207687] Wed, 06 December 2006 12:43 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Do you really think that Maria waited 2 years to solve this problem?

OK, better late than never, but ... huh, you dug out an ancient topic.
Re: Export oracle error messages [message #207769 is a reply to message #207706] Wed, 06 December 2006 23:54 Go to previous messageGo to next message
sukesh_DBA
Messages: 2
Registered: December 2006
Location: Calcutta , India
Junior Member

I got the same error 2 days back and could not get any resolution for the same not even in Metalink. So I thought of updating Orafaq with this resolution that I have tried out and succeeded so that anyone who comes across the same error later could get the resolution fast.

Regards,
Sukesh Roy
Oracle DBA.
Re: Export oracle error messages [message #207774 is a reply to message #207769] Thu, 07 December 2006 00:19 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I apologize if I was misunderstood; I didn't mean anything bad and certainly agree with you - it IS great to get the answer when you need it. Thank you for sharing it with us.
Re: Export oracle error messages [message #207939 is a reply to message #207769] Thu, 07 December 2006 08:07 Go to previous messageGo to next message
bwetkstr
Messages: 114
Registered: August 2005
Senior Member
sukesh_DBA wrote on Thu, 07 December 2006 06:54
I got the same error 2 days back and could not get any resolution for the same not even in Metalink. So I thought of updating Orafaq with this resolution that I have tried out and succeeded so that anyone who comes across the same error later could get the resolution fast.

Regards,
Sukesh Roy
Oracle DBA.



Thumbs Up
icon7.gif  Re: Export oracle error messages [message #311698 is a reply to message #207687] Sat, 05 April 2008 16:23 Go to previous messageGo to next message
mmpdba
Messages: 2
Registered: April 2008
Location: ATHENS, GA
Junior Member
I experienced the same problem and your solution worked perfectly.
Thank you ,
mmpdba
Re: Export oracle error messages [message #433208 is a reply to message #311698] Mon, 30 November 2009 12:05 Go to previous messageGo to next message
nsingh49
Messages: 9
Registered: August 2007
Junior Member
Guys,
Doesn't matter when you respond to an unanswered question, if you know for sure, you should update the link.

Sukesh Roy's answer actually save a lot of time for me today 11/29/2009.


Thanks Sukesh Roy..


Nirmal
Re: Export oracle error messages [message #451627 is a reply to message #433208] Thu, 15 April 2010 16:18 Go to previous message
elwood42
Messages: 1
Registered: April 2010
Location: Germany
Junior Member
Affirmative. Found the solution today; answered my question instantaneously. Thanks.

elwood
Previous Topic: Need to Import from 8i to 10gR2
Next Topic: Direct Path Loading
Goto Forum:
  


Current Time: Thu Mar 28 09:37:54 CDT 2024