Home » RDBMS Server » Server Administration » Export Utility Error in Oracle 9i  () 1 Vote
Export Utility Error in Oracle 9i [message #191296] Tue, 05 September 2006 10:00 Go to next message
samyak.mishra
Messages: 6
Registered: August 2006
Junior Member
Hello ,
while running export utility , i am facing this problem and even after lot of tries by running catproc.sql , catexp.sql , catrm.sql , catalog.sql is not getting solved at all ...
so i require your help to solve this error ....
here is the complete error when i run export utility ....

C:\Documents and Settings\Administrator>exp

Export: Release 9.2.0.1.0 - Production on Tue Sep 5 20:11:29 2006

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


Username: integ/integ

Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Enter array fetch buffer size: 4096 >

Export file: EXPDAT.DMP > d:\integ.dmp

(1)E(ntire database), (2)U(sers), or (3)T(ables): (2)U >

Export grants (yes/no): yes >

Export table data (yes/no): yes >

Compress extents (yes/no): yes >

Export done in UTF8 character set and UTF8 NCHAR character set

About to export specified users ...
User to be exported: (RETURN to quit) > integ

User to be exported: (RETURN to quit) >

. exporting pre-schema procedural objects and actions
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 19:
PLS-00302: component 'DBMS_REFRESH_EXP_SITES' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00083: The previous problem occurred when calling SYS.DBMS_REFRESH_EXP_SITES
.schema_info_exp
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 19:
PLS-00302: component 'DBMS_REFRESH_EXP_LWM' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00083: The previous problem occurred when calling SYS.DBMS_REFRESH_EXP_LWM.s
chema_info_exp
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 19:
PLS-00302: component '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.sc
hema_info_exp
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 19:
PLS-00302: component 'DBMS_TRANSFORM_EXIMP' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00083: The previous problem occurred when calling SYS.DBMS_TRANSFORM_EXIMP.s
chema_info_exp
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 19:
PLS-00302: component 'LT_EXPORT_PKG' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00083: The previous problem occurred when calling SYS.LT_EXPORT_PKG.schema_i
nfo_exp
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 19:
PLS-00302: component 'DBMS_AW_EXP' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00083: The previous problem occurred when calling SYS.DBMS_AW_EXP.schema_inf
o_exp
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 19:
PLS-00302: component 'DBMS_RULE_EXP_RULES' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00083: The previous problem occurred when calling SYS.DBMS_RULE_EXP_RULES.sc
hema_info_exp
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 19:
PLS-00302: component 'DBMS_LOGREP_EXP' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
EXP-00083: The previous problem occurred when calling SYS.DBMS_LOGREP_EXP.schema
_info_exp
. exporting foreign function library names for user SAF_INTEG
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user SAF_INTEG
About to export INTEG's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export SAF_INTEG's tables via Conventional Path ...
. . exporting table ACCESS_LOG
EXP-00008: ORACLE error 6550 encountered
ORA-06550: line 1, column 31:
PLS-00302: component 'DBMS_EXPORT_EXTENSION' must be declared
ORA-06550: line 1, column 14:
PL/SQL: Statement ignored


Thanks in advance ,
Sam
Re: Export Utility Error in Oracle 9i [message #191345 is a reply to message #191296] Tue, 05 September 2006 16:18 Go to previous messageGo to next message
kimant
Messages: 201
Registered: August 2006
Location: Denmark
Senior Member
You will probably have to upgrade/downgrade the exp packages installed, to match Your version of EXP.
Or use a version that matches Your database's current version.

Could the problem be that You have migrated from a previous version, and not run the script that installs the exp packages?

Br
Kim

Ps. A tip: Run EXP as a one liner, not interactive. This way it is much simpler reading and correcting errors.
Re: Export Utility Error in Oracle 9i [message #191362 is a reply to message #191296] Tue, 05 September 2006 22:40 Go to previous messageGo to next message
samyak.mishra
Messages: 6
Registered: August 2006
Junior Member
Hello ,
i also tried to run catpatch.sql and even that didnot solve the error.

as we can see the export release is 9.2.0.1.0
and so is the database version .

So is there anyway this can get solved.

Thanks ,
Sam
Re: Export Utility Error in Oracle 9i [message #191382 is a reply to message #191362] Wed, 06 September 2006 01:47 Go to previous messageGo to next message
kimant
Messages: 201
Registered: August 2006
Location: Denmark
Senior Member
Hi

I believe You should run catexp.sql.

Have You thought about utilize Support?

Br
Kim
Re: Export Utility Error in Oracle 9i [message #191403 is a reply to message #191296] Wed, 06 September 2006 03:10 Go to previous messageGo to next message
samyak.mishra
Messages: 6
Registered: August 2006
Junior Member
Hello kim,
i have already run catexp.sql , catpatch.sql ,catproc.sql ,catalog.sql and tried with no success. is there anything else ???
i am sorry but i donot know what is utilize Support ...
can you help me in this ....

Thanks & Regards,
Sam
Re: Export Utility Error in Oracle 9i [message #191430 is a reply to message #191403] Wed, 06 September 2006 06:13 Go to previous messageGo to next message
kimant
Messages: 201
Registered: August 2006
Location: Denmark
Senior Member
Hi

I mean that maybe You should call Oracle Support for this.

Br
Kim
Re: Export Utility Error in Oracle 9i [message #191444 is a reply to message #191296] Wed, 06 September 2006 06:56 Go to previous messageGo to next message
email.sandeepnaik
Messages: 121
Registered: August 2006
Senior Member
SQL>select comp_name,status,version from dba_registry;
make sure all components are valid

SQL>select object_name,object_type,status from dba_objects where status='INVALID';

If any invalid components are found, try compiling them. Run O_H/rdbms/admin/utlrp.sql multiple times to compile. If you still get list..try compiling them manually...

Sandeep
Re: Export Utility Error in Oracle 9i [message #427283 is a reply to message #191296] Wed, 21 October 2009 14:16 Go to previous message
Bill B
Messages: 1458
Registered: December 2004
Senior Member
This might be a silly question, but did you run the scripts while logged in the sys as sysdba?


Never mind, just noticed how old the message was.... Nevermind.

[Updated on: Wed, 21 October 2009 14:17]

Report message to a moderator

Previous Topic: NLS Settings DB level
Next Topic: can't increase sga_target parameter (merged 4)
Goto Forum:
  


Current Time: Thu Sep 29 00:33:29 CDT 2016

Total time taken to generate the page: 0.11366 seconds