OraFAQ Forum: Server Utilities » Export oracle error messages

Home » RDBMS Server » Server Utilities » Export oracle error messages

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Export oracle error messages [message #63777]

Fri, 05 November 2004 18:13

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%)

Report message to a moderator

Re: Export oracle error messages [message #63785 is a reply to message #63777]

Sun, 07 November 2004 10:24

Frank Naude
Messages: 4587
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

Report message to a moderator

Re: Export oracle error messages [message #207687 is a reply to message #63777]

Wed, 06 December 2006 11:06

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

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: Export oracle error messages [message #207769 is a reply to message #207706]

Wed, 06 December 2006 23:54

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.

Report message to a moderator

Re: Export oracle error messages [message #207774 is a reply to message #207769]

Thu, 07 December 2006 00:19

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: Export oracle error messages [message #207939 is a reply to message #207769]

Thu, 07 December 2006 08:07

bwetkstr
Messages: 114
Registered: August 2005

Senior Member

sukesh_DBA wrote on Thu, 07 December 2006 06:54

Report message to a moderator

Re: Export oracle error messages [message #311698 is a reply to message #207687]

Sat, 05 April 2008 16:23

mmpdba
Messages: 2
Registered: April 2008
Location: ATHENS, GA

Junior Member

I experienced the same problem and your solution worked perfectly.
Thank you ,
mmpdba

Report message to a moderator

Re: Export oracle error messages [message #433208 is a reply to message #311698]

Mon, 30 November 2009 12:05

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

Report message to a moderator

Re: Export oracle error messages [message #451627 is a reply to message #433208]

Thu, 15 April 2010 16:18

elwood42
Messages: 1
Registered: April 2010
Location: Germany

Junior Member

Affirmative. Found the solution today; answered my question instantaneously. Thanks.

elwood

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 13:55:37 CST 2024