| Export Utility Error in Oracle 9i [message #191296] |
Tue, 05 September 2006 10:00  |
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  |
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 #191403 is a reply to message #191296] |
Wed, 06 September 2006 03:10 |
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 #191444 is a reply to message #191296] |
Wed, 06 September 2006 06:56 |
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
|
|
|
|
|
|
) 1 Vote
] 
Blog
Search
Help
Members
Register
Login
Home
